You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

What's the difference of "For Each" action and adding for-each during mapping

edited Oct 28, 2019 6:12PM in Integration 5 comments

Content

Hi experts,

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!