single Parameter file read value for all the jobs

One Star

single Parameter file read value for all the jobs

Hi,

Is possible to read single parameter file to read all talend jobs? please one thing note, each job will read different value format.
say example :
parameter file have a value as:
job1:
lastdate;01-01-2001
deptno;10

job2:
lastdate;01-12-2001
deptno=20

the problem is, parameter name is same for all the jobs, but values are is different in each job. so each job should get the correct values in single fille.

is possible to do in any talend component?

Thanks,
Srinivasan S
One Star

Re: single Parameter file read value for all the jobs

hi All,

can anyone have idea above scenarios?

Thanks,
Srinivasan S
One Star

Re: single Parameter file read value for all the jobs

Hi Srinivasan S
I can't catch your point.
Could you explain it in another way?
Regards,
Pedro
One Star

Re: single Parameter file read value for all the jobs

Hi Pedro,
Thanks for the reply.
We have ten talend job, in all the jobs required different date condtion values and that date condtion logic used in same tcontext variable name.
for the date condition value, we used parameter files for changing the date condition values while executing job.
At present we used for the 10 talend job and 10parameter files for each job.
so can possilbe to use single parameter values to get value for all the jobs?.in all the job to get different date condtions values in single tcontext variable (context.LAST_EXTRACT_DATE).
it would be very helpful for my projetct if we solved above logic.

Thanks,
Srinivasan S
One Star

Re: single Parameter file read value for all the jobs

Hi
Yes. "context" is a private object in Talend java code.
If you don't use tRunJob component to pass the value of context variable between these jobs, you can use single parameter name.
Regards,
Pedro
One Star

Re: single Parameter file read value for all the jobs

Hi Pedro,
am using for the 10 jobs below same context name.
job1 required date condtion values is
context.LAST_EXTRACT_DATE : 2012-01-01
job2 required date condtion values is
context.LAST_EXTRACT_DATE : 2012-02-01
job3 required date condtion values is
context.LAST_EXTRACT_DATE : 2012-01-15
.
.
.
In the parameter file how we to differentiate in each job get different date value? do we have any screenshot any material?
My parameter file name as: test.param
job1:
LAST_EXTRACT_DATE;01/01/2012 00:00:00
job2:
LAST_EXTRACT_DATE;01/02/2012 00:00:00
job3:
LAST_EXTRACT_DATE;15/01/2012 00:00:00
One Star

Re: single Parameter file read value for all the jobs

Hi
You can use tFileInputPositional to read the specified positional value for each job.
Regards,
Pedro
One Star

Re: single Parameter file read value for all the jobs

Hi Pedro,
After we anlysed the tFileInputPositional component, we were not able to get solve the issue.
The parameter file dynamically generating with help of talend job.
hence, the parameter file based, can we assign the job get which values need to be assigned to the parameter file.
we are trying to achieve as like informatica standard to do in talend etl job.
In informatics parameter file format as like in talend :

$PMFailureEmailUser= xxxx
$$LAST_EXTRACT_DATE=02/03/2012 20:00:14


$PMFailureEmailUser=xxxxx
$$LAST_EXTRACT_DATE=03/03/2012 20:00:14
$$Email_Subject=ODS_Org_Contact SIL
$DBConnection_Source=xxx
$DBConnection_Target=xxx
same approach we need to do design in talend tool. please suggest same method how to proceed in talend?
Thanks,
Srinivasan S
One Star

Re: single Parameter file read value for all the jobs

Same issue here. We are trying to convert informatica mappings to talend. Any help would be appreciated.
Sixteen Stars

Re: single Parameter file read value for all the jobs

Informatica and Talend are different tools. Trying to use them in exactly the same way is like trying to use a high heeled shoe to trek a mountain. Talend does not allow you to restrict which context variables will be read from a file based on the job name. However, there are workarounds. You can have multiple context files which are pointed to by a central file. This allows you to read the contexts you want based on the job name. You can also store your context variables in a database, which provides the functionality you want.