Page 1 of 1

Job crashes in middle how to perform roll back

Posted: Thu Mar 10, 2005 7:24 pm
by kiran_418
HI
How to handle rollback in datastage when a job crashes in middle of run. I have a job that inserts 3 million records into oracle database. But after some time jobs craches due to some reasons. In that scenario how will datastage handle that scenario.
Thanks

Posted: Thu Mar 10, 2005 8:35 pm
by ray.wurlod
It will do whatever you design it to do.

Enrol in the "best practices" class, which shows techniques for staging data and recording process metadata so that you can figure out what was loaded and what wasn't.

And please post on the correct forum (server job forum?).