This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Do you know if it is better to perform an incremental load using parameters with Lookup & Foreach passing each source and target table one by one ? or on the contrary do you think it is better to create a Lookup and add Filter to copy each table in parallel ?
I have this doubt because there are more than 40 tables that I have to increment.
Thank you,
Best regards
Hello @Alfonso ,
Just checking in to see if the below answer provided by @Nandan Hegde helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Hey,
Note: There is a restriction of max 40 activities per pipeline in an ADF.
So whenever we design anything, we have to take that into consideration
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Hi All,
There is a 40 activity per pipeline limitation in ADF, and here is an existing feature request submitted by other users, I would encourage you to please upvote and comment on it which would help increase the priority of feature request. Here is the link: Increase the max activities included in a pipeline
Than you @Nandan Hegde for your contributions in helping the community :)