capturing error in talend

[sushantk19]

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.

[akumar2301]

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

[sushantk19]

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

[manodwhb · Accepted solution]

 @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:"")