Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to load context variable defined in the table into the jobs. Using project settings options for implicit context load, how to associate columns from a table to the context variables.
I have a table ETL_CONFIG with columns (PARAM,VALUE) I need to used the values from this two columns into the context load.
For. e.g
FILEDIRECTORYPE2 - E:/d/GND Rapid Phase/GND Rapid Phase/Sample Files/SM3 SAP imports/SM3 SAP imports/PE2/
here FILEDIRECTORYPE2 is the context variable and E:/d/GND Rapid Phase/GND Rapid Phase/Sample Files/SM3 SAP imports/SM3 SAP imports/PE2/ is value that is present as a row in the table, how to read this in the jobs using implicit context load option.
Thanks in advance
Hi,
Table used for implicit context load from database must contain "key" and "value" column.
See this link for explaination.
Thanks for the information. It is mandatory to have key and value as the column name? Also, if we have multiple context variables can we add it in table and it will be used in the jobs?
I did not get the query condition part, what query condition we need to provide there.
Hi ,
The only requirement on the table is that it has two fields called key and value,Other fields can also be part of the table . These will be returned in the result set and loaded into the job Context.In query condition you have to provide the condition like where clause.
Belowlink is helpful to you.
https://mindmajix.com/talend/managing-context-variables