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.
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?
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
