sram24_mca (6/5/2013)
We are planning to data warehouse the 2 different projects , to implement this we have to create the star schema from the 2 project database. Can anyone help us which approach is best to achieve this goal?
I assume that "two different projects" mean "two different data domains" therefore your dataware house would look like two datamarts, one for each data domain.
Absolutely impossible for us to model your star schemas but, you should be able to identify your FACTtual and DIMensional tables for each datamart, also which DIMensions can be shared by both like the ever present DIM_DATE dimension table.
Hope this helps.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.