UP_date column

dataservices job design
1

Hello all,

need to extract new data for the previous day based on the “UP_DATE” column in the source table.
No need to maintain history .I need to INSERT/UPDATED records based on UP_DATE column.

How can be this done BODS

Regards

vinay.sapds (BOB member since 2011-05-16)

2

I guess the easiest would be to make a query filter on sysdate-1 on UP_DATE in the source table, add a TC next and compare on business key then add a KeyGen then the target table.

SvenStrater (BOB member since 2015-08-26)