Hi All.
I m new in Talend ETL (most experience in SSIS).
Talend ver 4.2 and Oracle 11g DB.
How can I do this :
I have view.
I want to load data from this view with parameter
like :
Select * from V1 where f1 = 1
Select * from V1 where f1 = 2
...
Select * from V1 -- ALL data
So I need to pass parameter in job and use it in Query
I do OK it w/o parameters
but waht is way to pass them in job and use it in SQL (in SSIS there vars for that)?
Hi All
I can use variable in dynamic query now
Problem I don't know how to run job with different values of parameter
I can do it manually by swithcin contexts manually
I need now to run job with parameter 4 times
1,2,3,4 in automatic way (not manually) in sequence
:
job1 with par = 1
job1 with par = 2
job1 with par = 3 ....
Seems I need some parent job
May be Prejob is what I needs - but I can't undesrtand how to use it
ps I read docs - sure there is info but can't find it
Any references also will be apreciated
Hi Alevy - this is continuation of problem
I just need to run job with parameters many times
job1 with par = 1 then , job1 with par = 2 , job1 with par = 56 ....
I can set globalMap.put("par1" , "value1") in job
but don't understand how to pass it it Child job
or how to use context vars for that
I found how I can change them manually (set 2 contexts and change default one in job)
but I need to run Same job in programm way
"Problem I don't know how to run job with different values of parameter"
myjob.bat --context_param whereClause="where col1=6"
myjob.bat --context_param whereClause="where col1=4"
etc...
