CODEWITHSUNDEEP
postgresqletltalend
Yousuf Sultan
Yousuf Sultan

Reputation: 3257

Iterating a Talend job based on a condition

I have a control table in my PostgreSQL Database. Some sample data is shown below:

id    section_code    ddu_area    ddu_action    status_flag
1     4636            1           1             0
2     4636            1           2             0
3     4636            2           1             0
4     4636            2           2             0

I have few staging tables of each of the ddu_area's. There are a total 5 distinct ddu_areas. I want to pass the one id at a time and execute my ETL and id to be passed should have the status_flag as 0. When the status_flag is 1, it should take that particular id and pass it to the ETL job and take the data from staging to target.

I don't know whether we have this functionality in Talend or not. I am new to Talend. In SSIS, we can do this using For Each Loop container. What can I try next?

Upvotes: 0

Views: 539

Answers (1)

UmeshR
UmeshR

Reputation: 833

You have to use tFlowToIterate component to iterate over each record after that use tRunJob component to pass the parameters using various way you can see some of them here

your job flow should be like this. 

tFlowToIterate--if----tRunJob

Upvotes: 1

Related Questions