topic Re: [resolved] Passing multiple parameters on each job run in Talend Studio

[resolved] Passing multiple parameters on each job run

Anonymous — Fri, 27 May 2016 17:48:34 GMT

Hi
In my ETL environment I have a job that have to use multiple parameters. Parameters like param1, param2, .. param10. They are used inside job in sql scripts and components.
Each time job run i have to initialize that parameter list with some values.
These values are stored in database.
Should i do these through context param file?
I thought to fill context file each time automatically with shell scripts. But see some problems like that the folder, where context file lies, could change its name, because it has job version in its name.

Re: [resolved] Passing multiple parameters on each job run

Anonymous — Mon, 30 May 2016 08:35:41 GMT

Hi,
Have you already checked talend Implicit context load or tContextLoad which is used to load context parameters dynamically at the time of Job execution?
You can save values in a file or DB table.
TalendHelpCenter:Using the Implicit Context Load feature

Let us know if it is Ok with you.
Best regards
Sabrina

Re: [resolved] Passing multiple parameters on each job run

Anonymous — Mon, 30 May 2016 11:36:00 GMT

It seems that it could help me but i've got some problems.
Do you have more detailed, reference-like description of these feature and not just example?
I've set up a test job and got error:
Error: Parameter "LOAD_ID" has not been set by Implicit_Context_Context
In database i have a table with parameters of following structure
create table PARAMS(key varchar2(100),
value varchar2(100),
job_name varchar2(100));
insert into params values('LOAD_ID', '1', 'MY_JOB_NAME');
Third column job_name i need to store parameters for different jobs.
Seems like problem could be that my table for params has three columns. Not two (key, value) like in example.
But in job run log i don't see detailed log. What query it runs to get context from database, etc. Just Error.

Re: [resolved] Passing multiple parameters on each job run

Anonymous — Mon, 30 May 2016 11:39:15 GMT

In description of tContextLoad i don't see that it can load params from database.
help.talend.com/display/TalendOpenStudioforDataIntegrationUserGuide61EN/C.3.1+Preparing+context+parameter+sources
Just flat file

Re: [resolved] Passing multiple parameters on each job run

Anonymous — Tue, 31 May 2016 08:59:28 GMT

Hi,
Here is a related forum: https://community.talend.com/t5/Design-and-Development/resolved-Iterate-through-a-list-of-URL-s-for-tRSSInput/td-p/94539 about how to use Implicit tContextLoad in talend.
From component reference TalendHelpCenter:tContextLoad, you can change the input file component into a DB input component to read the parameter from DB table.
The work flow should be:t<DB>Input-->tcontextload
|
onsubjobOk
|
your other subjob
In addition, Implicit context load equals to use tContextLoad component in job.
Best regards
Sabrina

Re: [resolved] Passing multiple parameters on each job run

Anonymous — Tue, 31 May 2016 10:15:32 GMT

Ok
seems like I've resolved my issues with implicit context.

Re: [resolved] Passing multiple parameters on each job run

Anonymous — Wed, 01 Jun 2016 03:26:42 GMT

Hi,
Can we consider this topic as resolved?
Feel free to let us know if there is any problem in your job.
Best regards
Sabrina