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.
An integration platform-as-a-serviceto help enterprises collect, govern, transform, and share data from any data sources
Move from On-Premises to the Cloud by following the advice of experts
Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries