What is the best way to truncate source table.

xinhuang66 · Post by **xinhuang66** » Tue Dec 12, 2006 10:12 pm

what is the best way to truncate source table after job succeed, source table was in different server from target tables.

thanks

kumar_s · Post by **kumar_s** » Tue Dec 12, 2006 10:19 pm

Either include another stage after the target stage, or make use of Afterjob Subroutine with the command line options for the database.
But you can mention the edition of the Datastage, to get more appropriate answers.

DSguru2B · Post by **DSguru2B** » Tue Dec 12, 2006 10:31 pm

Have a second job that does the truncate. Or you can have a small stored procedure and call that stored procedure in the second job. Keep them seperate.

I_Server_Whale · Post by **I_Server_Whale** » Wed Dec 13, 2006 12:35 am

DSguru2B wrote: Keep them seperate.

I'm wondering the reason behind that suggestion.

Any specific reason? Why not do it in a single/same job?

Whale.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 13, 2006 1:05 am

One possible reason is looking ahead to the day when/if it's converted to a parallel job, in which it is not possible to do it in the same job.

Another reason is philosophical - the original requirement specified "after" - having separate jobs makes it easy to make this "after" relationship obvious in a job sequence.

DSguru2B · Post by **DSguru2B** » Wed Dec 13, 2006 7:02 am

Modularization, Restartability.