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
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables