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
TimMitchell.net | @tmitch.net | 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