topic Re: tOracleOutput Component - How to extract failed records in Talend Studio

tOracleOutput Component - How to extract failed records

IamHulk — Sat, 16 Nov 2024 03:24:39 GMT

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 ?

Re: tOracleOutput Component - How to extract failed records

akumar2301 — Thu, 30 Jan 2020 13:03:53 GMT

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

Re: tOracleOutput Component - How to extract failed records

IamHulk — Fri, 31 Jan 2020 05:59:03 GMT

HI Abhishek,

can u please provide example for this.

Re: tOracleOutput Component - How to extract failed records

Anonymous — Fri, 31 Jan 2020 08:12:32 GMT

An example could be :

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

Regards,

Pierre

Re: tOracleOutput Component - How to extract failed records

IamHulk — Tue, 25 Feb 2020 16:35:51 GMT

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