Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 DWH approaches

Author  Topic 

carumuga
Posting Yak Master

174 Posts

Posted - 2009-01-27 : 06:19:44
Hi,

I know that there are 2 approaches. 1. Top-down approach and 2.Bottom-up approach and i also know the difference between these two.

1. One thing i would like to clarify is, in which approach i can
connect the datamarts via conformed dimension and fact?

2. How datamart is created from EDW or how the datamarts are united to build the DWH in all the approaches...

Thanks in advance
   

- Advertisement -