SNOWFLAKE AND STAR SCHEMA
The snowflake schema is made up of one fact table connected to many dimension tables, each of which can be linked to another dimension table via a many-to-one relationship. In a snowflake schema, the fact table remains in the middle, surrounded by dimension tables. Tables in a snowflake schema are often normalized to the third normal form. However, each dimension table is further divided down into...
- 0 Comments
- 43 Views
- Share:
- 0
- 0
Posted By larinwa_2
3 months agoDIFFERENCE BETWEEN FACT AND DIMENSIONS TABLE
The fact table contains records with attributes from many dimension tables. These data enable users to assess various elements of their business, which can help them make better decisions and enhance their operations. The fact table, also referred to as the reality table, contains records that incorporate attributes from many dimension tables. That example, the records in the fact table may be a c...
- 0 Comments
- 46 Views
- Share:
- 0
- 0