Error strategy in Talend job

[sushantk19]

Hi,

I have a requierment to check if the value in a particular field is NULL after my target table is loaded. whats the best and easiest way to add this error strategy to my existing job? can i add something at the end of the job to check this? i am new to talend so looking for suggestions. if it finds a NULL value in column, then it should throw an error e.g "This is an error record"

[manodwhb]

@sushantk19 , if the field is null then you do not want to load into the target or you want to flag that record as error record in field.

[sushantk19]

Hi,

I want to flag the records as error records along with error text message in flat file for further Analysis. This needs to be done after my data gets loaded in my target table. what is best way to go about this?

[manodwhb · Accepted solution]

@sushantk19 , if that is the case 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:"")

[sushantk19]

ok thanks! that works!