loading data from 2 datasources into ODS without comonn key data

[Former Member]

hi,

I want to laod a ODS with 2 datasources without the common key data. I want to load the first datasource to the ODS and then load the second one,and second one should overwrite some common fields.It shouldnot add new records.

Thank you

Mandha

Edited by: mandha on Sep 27, 2008 12:47 PM

[Former Member]

Dear Manda,

If you dont have common key data 2nd datasource adds new records. It will not overwrited.

Try to load 2nd datasource to some other datatarget and write routine to look up data from that table. or

While mapping 2nd datasource, write routines to populate missing keydata. Then only overwrite possible.

But why you want do this...? Can you explain your requirement..?

Hope it Helps

Srini

[Former Member]

hi,

Here we are creating a cube for OTIF( On time In Full) calculation.The OTIF Will be calculated with Production planned date against the Actual Delivery date to the customer.We are getting the production planned date from one data source which is based on a table AUFK( We added some customer fields to it) and the actual delivery date we are gettting from another generic datasource which is based on customer table having the package information.In the second datasource we are just having Production Order not the production order position.

we are tying to mapp this.

1st datasource: 2nd datasource

Prod.Order Package Number

Prod.Order Position Package Number Version

Prod.Order Internal. Prod.Order.

Pord.Order Internal Position

........

regards

Mandha

[Former Member]

Hi Mandha,

Approach 1: Create an Infoset on 2 tables left outer join by keeping main table left at R/3 side and create a datasource on this and load. or

Approach2: Try to load both tables data into BW with datasources separately into 2 different ODS's and create a infoset on both of these ods and load into main ODS(loop back). As your key fields are same you can achieve this.

Hope it Helps

Srini