I have a requirement where I have to load the data daily in a table after deleting previous day's data based upon the column TRAN_DT(Transaction Date).
While deleting the data I have to make sure that I delete only previous day's data only and not today's and future day's data.
I have done the same through "Before SQL" property available in DB2 Connector stage in target using below query.
Code: Select all
DELETE FROM TABLE WHERE TRAN_DT < #BusinessDate#
Can there be any other approach other than creating another job ?