I have a global variable "passOrFail" set in globalMap. At the end of all the operations in a job, I need to check or "passOrFail" variable, if it is set to 1, I need to update a status value in DB as 1 else I need to update status value to 0. Can anyone please let me know how I can achieve the same ?
before your outputDB component check for global variable "passOrFail" value in java and set status value to 1/0 as per condition matched and let all other columns be as it is
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.