cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple loads to the data targets

Former Member
0 Kudos

Hi Gurus,

we have a data flow like loading data from 3 or 4 data sources in to one data target .Can you suggest me what are the advantages and disadvantages of doing like that?

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Gurus,

I want to know the advantages and disadvantages of loading data from multiple data sources to a cube

Thanks and Regards,

Ram

ssurampally
Active Contributor
0 Kudos

Hi,

You get this scenario, where you have multiple source systems. Each source system will have its own purpose/business.

When you are executing the reports at client which is top most hierarchy you need the data from all the source systems.

so you load data with many datasources. One datasource --> one source system

Thanks

Sreekanth

mathew_muthalaly
Contributor
0 Kudos

Hi,

I am assuming that you are talking about loading an Infocube from multiple datasources.

The pros and cons would depend on your specific scenario:

1. Type of Loads - delta/full loads

2. Frequency

3. Nos. of records

The scenario could get much simpler, if you loaded the data to different infocubes and reported off a multiprovider connecting them.

BR/

Mathew.