DataStage Job Hangs after rejected option fails &locks T
Posted: Mon Feb 19, 2007 8:46 am
I am using Datastage Version 7.5.1.A.
I am connecting to a 10g Oracle Server as my Database.
In my Job I am using a flat file to load data in a Table using
Dynamic RDBMS (DRS).
I have created a Target Link and a rejected link.
Inside the Transformer I have set the rejected option to True for the rejected link.
After executing the job If there is any erroneous data (required column missing or width greater than the allowed width) instead of those erroneous data going to the rejected link the job is getting hanged.
Can anyone give me any suggestion to circumvent this problem.
Any kind of help will be higly appreciated.
I am connecting to a 10g Oracle Server as my Database.
In my Job I am using a flat file to load data in a Table using
Dynamic RDBMS (DRS).
I have created a Target Link and a rejected link.
Inside the Transformer I have set the rejected option to True for the rejected link.
After executing the job If there is any erroneous data (required column missing or width greater than the allowed width) instead of those erroneous data going to the rejected link the job is getting hanged.
Can anyone give me any suggestion to circumvent this problem.
Any kind of help will be higly appreciated.