topic Re: How use implicit context load using database? in Talend Data Catalog

How use implicit context load using database?

Harich — Sat, 16 Nov 2024 00:02:40 GMT

Hi ,

I been using talend since few days i came across context variables using explicitly and loading path and values from file implicitly but im not able to do from database as implicit context. can any one please resolve it. Is there any prerequisite before using it.

Re: How use implicit context load using database?

Anonymous — Fri, 18 Jun 2021 04:32:57 GMT

First of all, you should create a table in DB, the table has two fields: key and value, the stored data looks like:

key value

varName1 value1

varName2 value2

...

In the job, use a tDBInput component to query data from the table, on the schema, define two columns: key and value.

the query on tDBInput:

"select key, value from tableName"

and link tDBInput to tContextLoad:

tDBinput--main--tContextLoad

|onsubjobok

other subjob

Regards

Shong

Re: How use implicit context load using database?

Harich — Sat, 19 Jun 2021 17:52:09 GMT

Thank you it really helped me without Confusion.