A job getting aborted when target table is truncated.
Posted: Fri Mar 27, 2009 12:00 am
There is a job in Product Quality which is getting aborted when the target table is truncated before the run but the same no. of rows are getting populated as before although the job is getting aborted.
Now,suppose the target table is having the records.When the job is rerun,it is getting finished successfully.
This parallel job was running fine in DataStage 7.5.2 whereas we are facing the problem in Datastage 8.1.
The job has Dataset as the source,the target is Oracle and transformer to transform according to the business logic.The rejected records from the Oracle stage are written into a Dataset.
Why it is happening????
Now,suppose the target table is having the records.When the job is rerun,it is getting finished successfully.
This parallel job was running fine in DataStage 7.5.2 whereas we are facing the problem in Datastage 8.1.
The job has Dataset as the source,the target is Oracle and transformer to transform according to the business logic.The rejected records from the Oracle stage are written into a Dataset.
Why it is happening????