Business Intelligence

The Merge Join Transformation and an SSIS Sorting Tip

July 5, 2020July 5, 2020 sqlswa5bgData Movement and Transformations

The Merge Join Transformation and an SSIS Sorting Tip My previous blog was about the SSIS Lookup task and how it really works. Now that I have shown that the Lookup task shouldn’t be used for one-to-many or many-to-many joins; […]

The Life Cycle of a Data Warehouse

June 28, 2020July 6, 2020 sqlswa5bgData Warehousing

The Life Cycle of a Data Warehouse All data warehouses should follow a standardized life cycle. Not all life cycles are required to be exactly the same either. In this post we are going to step away from the how-to […]