topic capturing error in talend in Talend Studio

capturing error in talend

sushantk19 — Sat, 16 Nov 2024 02:18:41 GMT

Hi,

i need to check if values in one of my target fields is NULL. if it has NULL value, then it show return an error message something like " this is a incorrect/missing value". I am new to talend. whats the best way to implement this considering i have already created a job to load the data to redshift tables.

Re: capturing error in talend

akumar2301 — Wed, 27 May 2020 15:30:43 GMT

1) you can use tSchemaComplianceCheck before load to Redshift . It will reject the NULL columns .

2) if you are not inserting in Batch mode , Reject Link should be enables on to capture reject on tRedshiftOutput

https://help.talend.com/reader/KxVIhxtXBBFymmkkWJ~O4Q/3FdX69lp6y62aXOikpeLXw

Re: capturing error in talend

sushantk19 — Thu, 28 May 2020 11:43:52 GMT

Hi,

The requirement is to check for error records after data gets loaded to my Target table. The error records are the ones which have NULL value and records along with an error message needs to be captured to a flat file. i am sharing my existing job design and settings of RedshiftOutput component. Please have a look and suggest what needs to be done now.

advanced_settings.png
basic_settings1.png
Error_tracking.png

Re: capturing error in talend

manodwhb — Thu, 28 May 2020 13:16:44 GMT

@sushantk19 ,After loading data into that target table you need to read that table and check for if the column values is null then you need write expression error column in tmap and connect to tfileoutputdelimited.

intmap expression should be like below

row1.col1==null?"col1is having null values"row1.col2==null?"col2 is having null values:"")