Reject link in the ORACLE CONNECTOR

igorbmartins · Post by **igorbmartins** » Thu Jul 15, 2010 1:39 pm

Hi my friends, is it possible set up a reject link in the ORACLE CONNECTOR?

Thanks

dougcl · Post by **dougcl** » Thu Jul 15, 2010 1:42 pm

Hi it appears to be possible if the connector is writing. It does not appear to be possible when the connector is reading.

igorbmartins · Post by **igorbmartins** » Thu Jul 15, 2010 2:03 pm

How can I set up? I am using to record in a table, but some records is not going.

My settings

Write mode: Insert
Generate SQL at runtime: Yes
Table name: My_Table
Table scope: Entire table
Enable quoted identifiers: No
Table action: Truncate
Generate truncate table statement at runtime: Yes
Fail on error for truncate table statement: Yes
Isolation level: Read commited
Record count: 2000
Array size: 2000
Process warning messages as fatal errors: No
Run before and after SQL statements: No
Manage application failover: No

ray.wurlod · Post by **ray.wurlod** » Thu Jul 15, 2010 2:38 pm

Drag second link from stage, right click on second link and choose "convert to reject". Pretty much everything else happens automatically, including sql code appearing on the reject link.

igorbmartins · Post by **igorbmartins** » Fri Jul 16, 2010 12:35 pm

Thanks

Sreenivasulu · Post by **Sreenivasulu** » Sat Jul 17, 2010 3:37 am

Reject link while reading - Looks to be a excellent feature for reconciliation of missing data

Regards
Sreeni

ray.wurlod · Post by **ray.wurlod** » Sun Jul 18, 2010 4:18 pm

Reject link while reading is meaningless, provided the metadata match what's in the Oracle table. You get what there is.