topic Re: Iterate order in Talend Studio

Iterate order

Anonymous — Thu, 12 Sep 2013 10:11:45 GMT

Hi,
I use a tFlowToIterate component.
After this component I have 2 iterate flow.
A the first, I read a table
A the second, I update this same table
My question is : There is a risk of deadlock ?
Can I be sure that my access of the table is end when I update ?
thanks a lot for your reply
Laurent

Re: Iterate order

Anonymous — Thu, 12 Sep 2013 10:34:56 GMT

Hi,
What's your job design, could you share the screenshot with us? Could you design two subjob for you requirement, one is for read table and the other for update.In addtion, there is "Muti thread execution" can be available in job setting.
Best regards
Sabrina

Re: Iterate order

alevy — Thu, 12 Sep 2013 15:54:11 GMT

If you have two iterate connections from the same component, one will be executed after the other not in parallel.

Re: Iterate order

Anonymous — Fri, 13 Sep 2013 15:30:07 GMT

Hi,
Thanks for your reply
I'm going to try to attach an image of my job.
If it's not work it's not a problem 😉
When I run my job, I haven't problem.
But with a lot of records, i have some doubts.
Thanks for your opinion
Best regards
Laurent

Re: Iterate order

alevy — Sat, 14 Sep 2013 00:43:47 GMT

I'm not sure why you have doubts. The iterates are run in the order they show. The easiest way to satisfy yourself is to look at the code the job generates. But you can also use OnComponentOK triggers from one step to the next instead of multiple iterates.

Re: Iterate order

Anonymous — Sat, 14 Sep 2013 08:30:34 GMT

OK, I see, thank you