We have handful of context variables in our jobs (DEV environment) out of which DB connectivity is also parameterized/contextualized, my question is when these jobs get migrated to Production where I don't have a choice to put in the passwords, how are these context variables expected to be refreshed with correct values. Any thoughts please
Do you also use context variable with Password type for password field? the value of context variables are loaded using tConextLoad during the job execution? If you don't know the value of DB connectivity parameters or they might change later, we usually read/load the value of context variables in the beginning of job from somewhere, such as a properties file.
Agree, that is a pretty standard way we do in other ETL tools, however in Talend for me to be able to load context variables from a file at the job level (at the start of the job) using Implicit tContextLoad I am concerned what happens to the rest of the project settings, do all the project settings stay as-is unless i override them through the tContextLoad? Please clarify.
