Post reply

star schema

  • April 8, 2019 at 5:13 am

    #3000872

    What should the fact table records look like with dim table relationships like this?

    FactTable has id1, id2, and id3 corresponding to DimTable1, DimTable2, and DimTable3. It has 5 corresponding records with DimTable1, 2 corresponding records with DimTable2 and 3 corresponding records with DimTable3.

  • April 11, 2019 at 10:51 pm

    #3137537

    Can you post real table definitions (even partial)?  It's impossible to answer your question with the current level of detail.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply