how to update a flag after each iteration from tflowtoiterate

[Anjali3]

Hi ,

tfixedflowinput -> tmap -> titeratetoflow -> Oraclerow

I have three input values to be iterated in this flow.For each input , once the iteration is complete , I want to update a flag in a redshift table to success. or if the iteration fails for another value , it should be updated to failure. Each iteration execution has to be captured separately.

But Im unable to update the flag for each iteration.Below flow is failing.

tfixedflowinput -> tmap -> titeratetoflow -> Oraclerow -> main -> tredshiftrow. 

if we use onsubjobok , Im unable to capture each iteration separately.

Please help.

[Anonymous · Accepted solution]

Hi,

    Please use On Component Ok in your use case.

tfixedflowinput -> tmap -> titeratetoflow -> Oraclerow -> On Component Ok-> tredshiftrow (success flow)

                                                                            |---> On Component Error-> tredshiftrow (failure flow)

Warm Regards,
Nikhil Thampi

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

[Anjali3]

Thanks ! It is working fine.