I'm completely new to talend and currently I need to build a job that reads params values like
This is what I have try so far
tFileInputProperties -------> tContextLoad ------> tPostgresqlConnection
Problem is the job is taking only one database connection instead of looping for all databases connection that I have defined in the file properties.
Can someone advice how i can create a Job that will loop params values on the tPostgresqlConnection component?
use Tflowto iterate between tfileinput and context and iterate and load to table.
I have showned inthis example,please find.
is your issue fixed?
Issues not fixed yet. Infact in your job logic I can't understand why you are using tInputFileDelimited and why there's no db connection?
I'm looking for a job that will loop on different db as to bring data in a data warehouse and I can't see this on your job.
It would be nice if you could provide more info.
in tfileinput, i take the parameters and tried to show there.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
This video will show you how to add context parameters to a job in Talend Cloud
This video will show you how to run a job in Studio and then publish that job to Talend Cloud
This video will help someone new to using Talend Studio get started by connecting to Talend Cloud and fetching the Studio License