data load from 3 datasource

[Former Member]

Hi,

I have to load an info cube from 3 datasource. how can i do it? will i have to create infopackage which can be loaded simulatneously in Process chain or IP one after another in PC??

Thanks

Prashant

[Former Member]

Prashant,

For these 3 datsources , you should have three infosources and you can put all the three in the process chain. But if you load first to the ODS with same keys you will get a very meaningful record in th ODS.

[Former Member]

i have migrated to 7.0 DS so no IS exsists for me right now. i guess i will have to add them in PC serially or in parallel as suits me :)...any other suggestions??

thanks

[Former Member]

Prashant,

You should add them serially in such a case.

[Former Member]

Hi,

since you have 3 datasources, you'll have 3 IPacks.

You can either include them in a process chain in parallel or serially; I suggest to try both options and measure the performance and system load.

hope this clears your doubts.

Olivier.