Five Stars

Implicit context load from Database

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

  • Data Integration
3 REPLIES
Nine Stars TRF
Nine Stars

Re: Implicit context load from Database

Hi,

Table used for implicit context load from database must contain "key" and "value" column.

See this link for explaination.


TRF
Five Stars

Re: Implicit context load from Database

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.

Five Stars

Re: Implicit context load from Database

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