topic Re: Error strategy in Talend job in Talend Studio

Error strategy in Talend job

sushantk19 — Sat, 16 Nov 2024 02:19:13 GMT

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"

Re: Error strategy in Talend job

manodwhb — Thu, 28 May 2020 05:36:34 GMT

@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.

Re: Error strategy in Talend job

sushantk19 — Thu, 28 May 2020 11:35:50 GMT

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?

Re: Error strategy in Talend job

manodwhb — Thu, 28 May 2020 12:44:56 GMT

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

Re: Error strategy in Talend job

sushantk19 — Thu, 28 May 2020 14:08:58 GMT

ok thanks! that works!