Full ETL Load into PRD working around system downtime
The problem we have got is some of the Informatica ETL tasks will run 30+ hours on Prod. But, we got overnight backups and batches, which means we got only 18 hours max per day and we got to stop ETL at this point. When we stop the ETL, it sends a truncate signal and wipes all the data out.
Is there a way to make a task not send the truncate signal, instead commit to that execution point and start from there if the ETL is stopped and started due to overnight activities on the production system? Or is there a way to say this task will run at this particular time, so that we can cancel the overnight backups?
Thanks in advance for any help you can offer