Extracting data from multiple datasources

[vikram_kate]

Hi all,

I want two fields(Creation and Change Date) from a single table to be used for delta extraction. So I created two datasources for that table using different delta fields.

Is it possible to extract using two different datasources and putting it in a single ODS without using FM?

Vikram.

[Former Member · Accepted solution]

Hi Vikram,

You can extract data from different data sources.

assign the datasources to infosources or infosrouce and create update rules to ODS.

Rgds,

Kusuma

[Former Member]

Hi Vikram

You can extract data from two different datasources into single ods, But see to that the two data sources should have common key fields,

Hope the above will help you..

bye

Shu Moh

[Former Member]

Hi Vikram,

You can extract from two different data sources and put it into a single ODS . But you test whether delta is working for both the data sources in RSA7 by creating and changing the documents . Also I think you will have to first load delta from data source (based on creation date ) and then load from delta data source ( based change date ) so that the correct delta sequence is maintained.

Regards,

Prakash