Managing Dimension Tables Part 2

In the previous section, you learned to use the Left Outer Join task to detect data changes that could affect your dimension table load processing. The Left Outer Join Merge task is a very powerful way to perform this kind of data inspection. The Left Outer Join Merge task reads all the data to perform the detection of changes. You will now learn an alternative way to perform this dimension data inspection.

Loading Dimension Tables Part 2

In this next procedure, you will learn how to achieve the same results as shown in the previous procedure but using a different technique for finding new dimension members. In the following procedure, you will learn how to use the Lookup task.

Add a new package

  1. Right-click SSIS Packages ...

Get Microsoft® SQL Server™ 2005 Integration Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.