Target pre and post sql

[dbatlanta]

I need to delete three days(sysdate-2, sysdate-3, sysdate -4) data from my target table. Then I need to update three days (sysdate-3,sysdate-2,sysdate-1)data from the source table.

How do I accomplish this?

Is there a way to use the pre sql in Target properties to delete rows for three dates for the target. and use a sql override in the source qualifier to select rows for three dates and insert it into the target table.

 

[blom0344]

Any valid SQL that you fire at the target will be excecuted first. You need to find the proper syntax to delete the recordset you want to delete.

However, you could investigate the possibility to split the process of deletes/updates based on the fact that you can use the sysdate in expression/filter WITHIN the mapping.

If that does not work out , then you could build a multi-pass , first having a run that performs the deletes and then a second one that performs the updates

Ties Blom