What's the difference of "For Each" action and adding for-each during mapping
In integration we are reading one file which has multiple lines, after that we want to call a DB procedure for each line(line value as input parameter or procedure).
One way is in integration we use For Each action and call the procedure within the loop
The other way looks to be during mapping, add for-each(mapping readfile lines) at the top of procedure call request
Will they behave the same? Is that the 1st one will call DB agent multiple times but the 2nd one will only call DB agent once?
Suppose there are 20000 records from source file, which one would be better?