cancel
Showing results for 
Search instead for 
Did you mean: 

Updating Data from 3 infosources to one CUBE parallely

Former Member
0 Kudos

Hi experts,

I am having 3 Infosouces having data from 3 different regions.

How to upload data into 1 cube from three IS s at a time with a single REQUEST.

Thanks,

sunil.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

Create 3 update rules for these 3 infosources to the cube and create the info package and load.

Single request, it is not possible to do it..... Once u start the loads from 3 IP's then 3 requests will be updated in the cube.

Khaja

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

the "single request" is questionable....

anyway you might have your valid reasons....

Put a staging ODS in between your 3 ISources and your target cube. You'll get your single request.

hope this helps...

Olivier.

Edited by: Olivier Cora on Jan 9, 2008 11:41 AM

Former Member
0 Kudos

Why do you want to have it in a single request ?

It is not possible as these are 3 diff jobs.

Former Member
0 Kudos

Hi,

You will have to create update rules from three infosources for the cube to which you want to upload. And then use infopackage to do the load.

I dont think you can do it in any other way with a single request.

Regards,

kalyan