Skip to Content
0
Former Member
Mar 22, 2009 at 02:01 PM

Delta in Generic datasources.

18 Views

For the generic datasource. I have to run Delta multiple times per day. In this case I hope that, TIMESTAMP is the suitable option to run delta. Here, to set up TIMESTAMP, I have to select the field name for Delta, based on that field name the delta will work and pick the records into BW side.I have 2 fields DATE and TIME to set up delta. I have given field DATE for delta.

For example.The data in the source system is

IC DATE TIME

XX 22/03/2009 09:30:41

I will run delta on 22/03/2009, 10 AM , then the above record will go to BW successfully.

At 11 AM one more record will be added into the source sytem on the same date 22/03/2009. Now the data in the source system is

IC DATE TIME

XX 22/03/2009 09:30:41

YY 22/03/2009 11:00:00

Again, at 11:30, I will run delta to pick the 2nd record. Here my doubt is, will that 2nd record be picked into the BW?. I doubt that, as we have set up delta based on the field DATE, Will the 2nd record will be picked into the BW side or not?. If the 2nd record will not be picked into the BW side.

How can I achieve this. But, I need to run multiple times per day and need all records.

Please let me know if you dont understand.