Dynamic task mapping vs many parallel operators

Prefer a staging table plus validation gate before promoting to prod tables.

Small nit: the broadcast hint gets ignored once the table is over threshold, check the UI to confirm.

Yes, the partial index was the win for us too.

Worth measuring the serialized size before choosing broadcast.

Start with the execution plan, numbers beat guesses.

Note that merge on Delta still needs unique keys defined correctly.

Careful with NULL in join keys, they'll drop rows in an inner join.

Sometimes the real fix is a product change so you stop needing that join at all.

Any downside to this approach with incremental models?