Hope you are well.
I have got the scenario where I am looping in all 3 excel files stored locally and then loading them into Redshift.
I have designed my job like this:
This is my setup in tfileinputexcel.
It actually shows 2 exection finished but it actually loads only one file in redshift. Not sure what am I doing wrong.
Thanks in advance.
Solved! Go to Solution.
Could you please add a tRedshiftCommit to tRedshiftOutput using On Component Ok? Please do not close the connection since you need to repeat the iterations. You can close the connection in tPostJob section once the entire job is complete.
At the same time, add Die on error option in tRedshiftOutput component to make sure that data is indeed getting loaded without any error.
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Read about some useful Context Variable ideas