I need the number of recipients with "Email comecial" not empty, meaning they have an email comercial.Appliying a filter to the schema shows there are 7M recipients where email comercial is not empty. But using a workflow to query the recipients table and then and split activity, to not only get the...

Oh yes, we do only update some records, the ones that changed normally. I just happened to need to load all the records this time. I thought you're mentionend other functionality besides batch size. 

Hi Manoj, about: Can this be changes to incremental load instead of full load?What would be the best approache to do incremental loading? Using a split activity? Filtering by an incremental PK column?Ty

After talking to Adobe Support, they sent me a list of other workflows that needed to be stopped. We went for a batch of 2K  every 4 min, to a batch of 600K and lastly 800K.  So apparently, stopping other workflows can increase the batch size proceesed , even making it higher than what was originall...

One of our workflows, started on 08/28 and we estimate it is going to finish on 01/09, 04 days after it started.It loaded 24M records and it has to update all of them. The time is spent on the update activity that has 200,000 as batch size. It targets the recipients table.Is this normal? Is there an...

Hi, I want to be sure there will be no issues when other users try to query the recipients tables if it's main workflow (where it gets updated is still running).From this link, the locking happens when other processes (workflows) try to do changes in the tables (e.g. recipients):The example below il...

Is there a good batch size for an update activity?There are some workflows that take 5 to 8 hours to ingest/update the data into our schema. I'm thinking going from 10,000 to 200,000.  I've tested with 80,000 and 100,000 and everything seems fine.Is there anything I should be aware of about this big...

Hi @ParthaSarathy , any documentation on what  mask="2" means? Maybe there is mask 1,3,4 etc.Doing "Unconditional stop" doesn't change the paused activity to other state. There are more than 200 workflows with a paused activity. Is there any action I can do as a "Mass updated of selected lines" ???

Some users pause activities inside the workflow. Since the status says "finished", I thought they have ended and that paused activity meant nothing. However, I've been told by Adobe Support that those workflows are consuming resources.What would be an efficient way to stop all of them? How can I fil...

So, would be 5, 10 foreign keys ok?For the rest of the tables, the best approach is to use Enrichment activities to make any joins we need?