job fails while loading into target table
Posted: Mon May 04, 2009 2:40 am
Hi All,
Can anyone please guide me how to restart the job incase if the job fails .
for example i have 2million records to be loaded into the table.
i have input a seqential file or the dataset needs to be loaded into sybase database.
i want to just use insert commmand by deleting the perious records.
While loading 2milllion records if the job fails at 10000 records then how to handle in such senario.
I checked in forum it tells about hash file or caputure the record.
but how exactly i need to work on,as i am new to datastage not able to get the required results..
please guide..
Can anyone please guide me how to restart the job incase if the job fails .
for example i have 2million records to be loaded into the table.
i have input a seqential file or the dataset needs to be loaded into sybase database.
i want to just use insert commmand by deleting the perious records.
While loading 2milllion records if the job fails at 10000 records then how to handle in such senario.
I checked in forum it tells about hash file or caputure the record.
but how exactly i need to work on,as i am new to datastage not able to get the required results..
please guide..