delta upload from external tables in BI 7.0

[Former Member]

hi guys!

i need to create a delta upload reading the data from an external db

what are the options that i have?

there is someway to use the timestamp that i have in the source tables

and make a comparison between the timestamp in ods and the timestamp into the PSA?

i have to use the rso2 transaction or simply a DTP?

in bw i don't have the field type timestamp

but only time or date

how can i take the source timestamp into bw?

if i try to define the timestamp fields as char 14 a don't receive any data in that fields with the preview

what kind of data type i have to use?

thanks in advance

Emiliano

[Former Member]

RSO2 is basically for R/3 Source system.Delta is possible only with R/3 systems.

The changes in the legacy system has to be captured in the legacy system. The daily changes you can write it in a file or a table and from that you can extract data.

Regs

Gopi

Assign points if it helps.

[Former Member]

Dear Emiliano,

1. Have two fields in BW, one each for date and time.

2. Separate the time-stamp in the source system in to Date & Time fields separately. For this try creating a view.

3. Else, write a two small routine (for each of the two transformation) to read the time-stamp in BW.

Hope this helps!

Thnx & Regards,

Ramesh