Star schema modeling challenge along with security implementation

Comments

1 comment

  • Avatar
    Adam Bender

    You can create a relationship between dim tables, you just have to be careful how and when you do it.  Remember, they are all inner joins.

    As long as there is a 1:1 relationship between client and channel, you can create something like the diagram below.  dim_channel will filter dim_client, which in turn will filter your fact tables.

     

    Your dim_channel should exist as an "outrigger" dimension of "dim_client.

     

    0
    Comment actions Permalink

Please sign in to leave a comment.