Loading Type 1 and Type 2 Dimensions made Easy with Task Factory

Ever had to load a Data warehouse? Isn’t it so much fun creating all of those transforms to load a type 2 dimension? Of course it’s not; it is a lot of work. Well now you can load those dimensions very easily using Task factory.

Task Factory is a group of almost 30 tasks that you can add on to SSIS. These tasks make your job much easier. Instead of creating dozens of task, you can use just one Task Factory task to accomplish the same work.

Usually you would need a data flow like the following image to accomplish a type 1 dimension load.

 
With Task Factory’s Upsert destination your data flow will look like this.

 
You can see how this is simplified the work and saved you a ton of time. The Upsert has a very user friendly interface seen here.
 

I know what you are thinking, what about the dreaded type 2 dimensions? Fear not, Task factory has that covered also.  Below you can see the Dimension Merge Slowly Changing Dimension.
 

The Dimension Merge Slowly Changing Tasks also has a very easy to use interface seen below. You can decide which columns are type 1, type 2, AK,’s, Effective Date, Expiry Date, and SK’s.
 

These are just a couple of the components in Task Factory. For a complete list and to download a trial visit PragmaticWorks.com. They even have a free version.