Good site for Data Warehouse discussion

Discussion in 'microsoft.public.sqlserver.datawarehouse' started by tshad, Jan 28, 2011.

  1. tshad

    tshad Guest

    Is there a good place for Data Warehouse discussion?

    I have a project where I am building a Data Warehouse and am using SSAS and
    SSIS to build and use my dimension/fact tables. I had it working fine for
    one database but need to use the same tables for the other databases the
    company has.

    The issues is that there are multiple databases using the same table
    structures for the different companies it is involved with.

    They all have some of the same stores in them. I had thought about using
    surrogate keys with the actual keys as the alternate keys so I can find the
    correct store from the base tables. The problem is that if I have 5
    databases and is the same store in all 5 database, I will have 5 different
    store records with different surrogate keys and natural keys.

    I was thinking about making a table that cross references one of the stores
    and use that table to get the correct store from the dimension table but am
    not sure that is the best way.

    I was trying to find a best practises way of doing this but can't seem to
    find anywhere where they show an example.

    Thanks,

    Tom
     
    tshad, Jan 28, 2011
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.