Capture reject records

dr.murthy · Post by **dr.murthy** » Tue Sep 18, 2012 2:04 am

Hi,

My target data base is oracle , i use OCI stage to load records , when i load the data its throwing warnings like ORA-01722: invalid number. i dont want to load these records into target , i want to load in reject file . when i give the constraint to reject link its loading the rejected records into file and throwing the same warning,

Any suggestions to over come this issue.

thanks in advance

ssreeni3 · Post by **ssreeni3** » Tue Sep 18, 2012 2:11 am

Hi,

Oracle target stage has an option to capture the Oracle_Rejected data.

---------------
Sreeni

dr.murthy · Post by **dr.murthy** » Tue Sep 18, 2012 2:41 am

Am working on server jobs, it does not have reject option in oracle stage

jerome_rajan · Post by **jerome_rajan** » Tue Sep 18, 2012 3:06 am

You can use the oracle connector within a parallel container in your server job

dr.murthy · Post by **dr.murthy** » Tue Sep 18, 2012 4:36 am

is not there any other solution ???

ray.wurlod · Post by **ray.wurlod** » Tue Sep 18, 2012 6:54 am

Why didn't you post the question in the Server job forum?

In server jobs the reject link from a Transformer stage that feeds the OCI stage is used to capure rejected rows. Link variables can be used to capture the DBMS error code and message.

chulett · Post by **chulett** » Tue Sep 18, 2012 7:24 am

jerome_rajan wrote:You can use the oracle connector within a parallel container in your server job

I think you've got that backwards.

chulett · Post by **chulett** » Tue Sep 18, 2012 7:26 am

Well, here we are in Server Town now.

dr.murthy wrote:when i give the constraint to reject link its loading the rejected records into file and throwing the same warning

That's how it works, the warning is always logged.

DSXchange

Capture reject records

Capture reject records

Re: Capture reject records