Hi Russel,
Incremental loads usually involve capturing the latest transaction date/timestamp that was delivered in a target table and compare it to the source date/timestamp.
I would create a global variable (GV) to capture the last transaction date/timestamp in the DS JOB and then use the GV in the query transform used to extract the data from the source table. You would compare the GV to a date/timestamp defined by the source owners.
Hope this helps.
Cheers,
John
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.