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.
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Move from On-Premises to the Cloud by following the advice of experts
Learn about modern data engineering in the Cloud
Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries