You are not logged in.
I need to perform following job:
There is a job named Daily_ETL which populates certain MySQL tables on a daily basis, when the a date parameter is passed to it.
Now I want to make version 2 of this job which populates those tables for past dates [for cases where we are populating the tables for first times and have a data unprocessed for lets say last 2 years]
For that purpose, I have a table in database which lists all dates (from 2 years back to current date).
I want to read that table row by row and pass on the date value to my job which essentially has SQL queries. The date parameter shall be embedded in those queries.
I tried tMysqlInput ->tJava [to print the date values] but all it prints is null.
I'll be greatly thankful if this gets resolved
I have attached snapshots of the job so as to correct me where I'm going wrong.
PS- I'm new to forums
As you have worked on date , do you know how to work on time type...
Talend doesnt suppot only time data type I guess...
Please need a help regarding this...
All the Talend date method can be found in Talend code-->routine-->TalendDate where you can find all and globalMap.
you cannot write a flow in a tJava component (or using using iteration like JohnGarrettMartin suggestion).
It's the reason you 've got null value.
To flow data through tJava componenet, use tJavaRow.