ETL and Data Integration tools - Modern ETL software for everyone

Hi,

Need Immediate Help. I need to add reload strategy to my data transformation.

The reload strategy is, when transformation fails it should delete the records that were inserted the same day.
But if the session is successful, we want to delete the old records from previous day.

Can we do it with SQL After?

Thanks,
Chris

Chris

SQL after will not work in your case

You would need to create a package like on picture attached.

Assuming that you are using Oracle you can use the following syntax

delete from orders where trim(order_date)=trim(SYSDATE) -- deleting today's orders

delete from orders where trim(order_date)=trim(SYSDATE) - 1 -- deleting yesterday's orders

Happy NY
Peter

Thank you Mike

I will try that

Chris

Another thing you can try is to calculate number of records before and after the transformation.

Mike