Home » SSIS
Using a Lookup Component in SSIS for Surrogate Keys in a Fact table
There are many suggestions for loading a data warehouse using SQL Server integration Services (SSIS). Once you get started, you find a pattern to repeat for facts and dimensions. This might be because the consistency Dimensional Modeling suggests…
Read More »Why use a Date Dimension Table in a Data Warehouse
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you are using the Kimball Dimensional Modeling method. In the beginning of Dimensional Modeling, it was called a Time…
Read More »