topic twaitforsqldata component clarification in Talend Studio

twaitforsqldata component clarification

BA621858188 — Fri, 15 Nov 2024 21:46:10 GMT

Hi All,

I am looking to clarify my understanding of the below points. Please help me here.

I am using the twaitforsqldata component, and max iterations as empty means infinite; each iteration takes 5 minutes, and it is waiting for the data on one table based on certain conditions. I wanted to know if the data didn't arrive in the table until 14+ hours, then the job would fail, or if it would still run every 5 minutes to check the availability of the data.

Please let me know if there are any additional things we need to consider so that our job won't fail.

Thanks in advance.

Re: twaitforsqldata component clarification

Anonymous — Fri, 26 May 2023 03:19:49 GMT

Depends on the 'Trigger action on rowcount' condition and 'Then' action, if you set the rowcount equals 0 and then exit loop, the component will exit the loop.

Regards

Shong

Re: twaitforsqldata component clarification

BA621858188 — Fri, 26 May 2023 06:02:09 GMT

Hi @Shicong Hong ,

rowcount is set to 1, and the exit loop is selected.

Re: twaitforsqldata component clarification

Anonymous — Fri, 26 May 2023 10:49:18 GMT

if there is no data coming, the rowcount is 0, the loop will continue to run every 5 minutes.