Chapter 49. Late-arriving dimensions in SSIS
John Welch
SQL Server Integration Services (SSIS) is a great tool for populating data warehouses. Straightforward, common approaches in data warehousing are easy to implement. But certain scenarios can be more complex to implement using SSIS, particularly if you’re moving a lot of data and have aggressive performance requirements. Late-arriving dimensions are one of those scenarios.
Late-arriving dimensions (sometimes called early-arriving facts) occur when you have dimension data arriving in the data warehouse later than the fact data that references that dimension. This chapter discusses several options for handling late-arriving dimensions in SSIS.
A late-arriving dimension scenario
In the ...
Get SQL Server MVP Deep Dives, Volume 2 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
