capture rejects using Oracle Enterprise edition stage

[pavan_test]

Hi All,

How do I capture a reject file with sql code and sql error using oracle enterprise edition stage.

I am trying to insert 100,000 records into oracle data base. if there is only 1 bad record it rejects all the 100,000 records with a sql code 1403.

I want to capture only the specific record(s) that get rejected from Oracle enterprise edition stage in the reject file with sql error and sql code. it helps me to debug the data if that is case.

thanks
Mark

[ray.wurlod]

First off, what Write Mode are you using?

Have you drawn a reject link from the Oracle Enterprise stage? Direct this, through any other stage types you feel to be appropriate, to a Sequential File stage to capture the rejects.

[Pagadrai]

Hi All,
if there is only 1 bad record it rejects all the 100,000 records with a sql code 1403.
Mark

Hi,
Can you explain more on this.