Package Organization for a Data Warehouse

[Goodie666]

Hello,

I'm in the process of building a sample data warehouse and I would like to get some feedback regarding the package layout people generally use. I was thinking of having a master package that calls 1 package for all dimensions and 1 package for each of my fact table. I was wondering what kinds of organizations people usually use and for what reasons?

Many thanks,

Greg

 

[MDXer]

it is best to keep your packages as granular as possible. 1 package per dimension and 1 package per fact table. you can then have a master package that executes the packages as needed.

In my current enviroment I have a package for each dimension and fact then I have a load package for the dimension that executes the dimension packages and same for the fact process. These to load packages are executed from a Master package that executes these 2 plus other needed packages.

 

[Goodie666]

Ah I see. I was debating whether to treat all dimensions in one package or several. I think I'll go with your idea, it would be the most granular and not necessarily too complicated to implement neither.

Thanks,

Greg