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.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.