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
Right-click SSIS Packages ...