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.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema