Home Forums Data Warehousing Analysis Services How to Define a schema for the fact table, and the dimensional tables in SQL from a relational schema? RE: How to Define a schema for the fact table, and the dimensional tables in SQL from a relational schema?

  • Is it necessary to define the address as a hierarchy?

    Also, do you mean these primary keys in those tables are redundant?