May 20, 2009 at 11:50 am
Hi all.
We are going to create SSIS packeges to load data into dimentions as well as facts. What is better approach: to create one package that will load all or dedicated package for each dimention and fact ?
What are pro and cons for one or another method ?
Thanks.
May 20, 2009 at 7:14 pm
I was discussing a similar topic with someone else earlier this week:
http://www.sqlservercentral.com/Forums/Topic720042-148-1.aspx
We were discussing the use of multiple data flows vs. a single data flow, but some of the same points could be made. Personally, I prefer to keep units of work together, so I'll use a single package and will isolate my processes for performance using multiple, sequential data flows.
An exception to this is when I expect to run a particular subset of that ETL process by itself. If you plan on running your fact/dimension ETL processes independently of one another, even if you will do so infrequently, you'll be better served to create separate packages.
hth,
Tim
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply