Using multiple APPLY clauses (operations within an APPLY statement), it is possible to extract data and simultaneously load it into as many as 32 targets in a single job step.
This read-once-apply-to-many approach allows source data to be loaded into multiple targets, ensuring that each target receives identical data. By using multiple APPLY clauses, multiple updates and loads can now be accomplished with fewer system resources compared to creating separate job steps for each load or update, thereby redundantly extracting data from a data source.