topic Re: tWaitForSqlData in Talend Studio

tWaitForSqlData

RHZ123 — Tue, 14 Apr 2020 17:39:55 GMT

Good morning all,

I am analyzing a job at the end of evolving it, I come across a tWaitForSqlData component, I read the documentation for this component, I understood its general functioning, but there is one thing that escapes me in the advanced settings, what it corresponds to, and how it works (on the part activate WHERE clause)

In the job I'm analyzing, they have this thing :

Re: tWaitForSqlData

Anonymous — Wed, 15 Apr 2020 03:47:28 GMT

The where cause filed allows you to add a where condition for the rows counts, for example:
"WHERE name='talend'"
Assuming we select 'trigger action when rowcounts is great than value 2, if there exists more than 2 rows that the name filed has 'talend' value, the trigger will be activated.
If the where cause box is unchecked, it will count all the rows.

Regards
Shong