tOracleOutput Component - How to extract failed records

[IamHulk]

Hi,

I am using oracle input component to read table and write the data to the oracle table using oracle output component after using some join conditions and transformation. Some records are failing to insert into the database tables because of the invalid format.I am not able to see the failed record data in the console, Is there way to extract the failed records ?

[akumar2301]

Always better to do schema check just before tOracleoutput. You will have reject of schema which can be logged to file db or console

[IamHulk]

HI Abhishek,

can u please provide example for this.

[Anonymous]

Hi

An example could be :

tFileinputDelimited --> tSchemaComplianceCheck -- Schema_OK --> tOracleOutput

Regards,

Pierre

[IamHulk]

i am using dynamic schema this component will work for dynamic schema?