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?

  • Regarding the address: typically you would store the street and number in one field, but zipcode, town and country in other fields. Maybe in a different dimension altogether: the geography dimension.

    Regarding your dimension tables: in correct dimensional modelling, you add a surrogate key, which is a meaningless integer key. The fact table will hold the surrogate keys because they are smaller than your business keys. It also makes your joins quicker.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP