Sequence job performs the table loads.These tables have a parent child relationship.First the Parent table is loaded and then after a sequence the child table will be loaded.
My requirement is to delete data from all the tables before I start the sequence job.Here we need to delete data from the child table first and then the Parent table
Which is the best method to delete data from tables which have parent child relationship.
TO delete data from tables before execution of sequence job
Moderators: chulett, rschirm, roy
TO delete data from tables before execution of sequence job
Manu
Datastage Devoloper
Datastage Devoloper
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: