topic Re: tdbinput---iterate---tdbsp in Talend Studio

tdbinput---iterate---tdbsp

Anonymous — Sat, 16 Nov 2024 04:30:11 GMT

Hi,

i have designed my job like this

tdbinput--tfilterrow--tflowtoiterate--tdbinput---(iterate)--tdbsp---tlogrow

tdbinput--tfilterrow--tflowtoiterate--tdbinput---(main)--tdbsp---tlogrow

By using iterate, I was not able to sync columns by default so adding schema manually in the (tdbsp)schema but if i use main flow, i am able to sync schema by default hence getting the correct result.

so, If I use iterate between tdbinput & tdbsp --- I am seeing null values

If I use main between tdbinput & tdbsp --- I am seeing values in tlogrow.

Could you pls help me here with iterate option.

ThanksIn Advance,

Nik

Re: tdbinput---iterate---tdbsp

vapukov — Wed, 02 Oct 2019 09:59:59 GMT

Hi Nik

you are right - all as described, and it is correct

what is your problem with using main connection instead of iterate?

regards, Vlad

Re: tdbinput---iterate---tdbsp

Anonymous — Wed, 02 Oct 2019 16:47:52 GMT

Hi vlad,

Thanks for your response.
I thought it will not iterate if i use main between TDBINPUT and TDBSP but it does and got the expected result.
Is it only between these two components and do you know the reason?

Thanks,
Nikhitha

Re: tdbinput---iterate---tdbsp

vapukov — Thu, 03 Oct 2019 22:18:20 GMT

not sure what exactly your question about, but you need to understand the logic

tFlowToIterate it is a loop, with a condition - "for each row from the source dataset"

component do not transfer data flow, but instead, it stores each row values to related global variables

by default each column stored to a global variable "connection name.column name" ("row1.column1")

than loop execute the following group of components, it could be separate data input, but you can use stored variables as parameters anywhere inside the loop iteration