The Definitive Guide to Data Quality
Yes, it's wonderfull if I can be made this from the parent job, but the problem is the same.... I can't retrieve the value in the context var, always null.
The josbs that I've made is an example.
The real need I have and the reason for that I need it, it's because the context var value will be retrieved from more than one parent jobs.
The idea is make a child job that instantiate the context var, and from other parent jobs, retrieve its value.
Thanks very much for your responses.
I'm very new to Talend and am still trying to get my head around "thinking in Talend". That is trying to figure out which components and arrangements are best to accomplish a particular goal. The problem I'm having is passing a context variable to another component in the same job. What I want to do is create a date dimension. I've set up a loop to generate a list of numbers. These numbers are passed to a tJava and then tJavaRow where each number is a day added to a java Calendar to increment days. I then (using Java) create all the attributes for that day. I pass these attributes through a tMap and on to a database table. This all works fine.
The next step in the evolution of this job is to look at the existing database table and only insert a new day record if it does not already exist in the table. I added a second database connection (tInformixInput) and added SQL the queries for the day record in question.
"select date_dimension_key, full_date_name from date_dimension where date = date('" + context.strCurrDay + "')"
If I don't default the strCurrDay value my SQL always crashes because it's null. If I set a default value, that value is always used and not updated. BTW, the context variable is updated in the tJavaRow with each iteration of the loop. I have a tLogRow component which is showing me the context.strCurrDay from the tJavaRow component and the result of the SQL query. tJavaRow is indeed stepping through the days, but the database connection is not. It is not getting the new value(s) for the strCurrDay.
What am I doing wrong? I have some screen shots, but don't now how to attach them here.