Multiple Fact Tables RRS feed

  • Question

  • Hi All,


    How to design a DW to include fact tables from different databases on the same server? I am looking for best practises and guidelines to to those. Please recommend me links for the same.


    What I have followed is adding second data source which made my first data source as primary. My second DS includes tables from the tables which are fact tables. My question is do i need to have dimension table from the second DS to relate the tables of the primary DS because when I process them it gives me a error Invalid Object Name.




    Tuesday, June 24, 2008 11:59 AM

All replies