Star schema modeling challenge along with security implementation


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.


    Comment actions Permalink

Please sign in to leave a comment.