Data warehousing - What is degenerate dimension table?

What is degenerate dimension table?

The dimensions that are persisted in the fact table is called dimension table. These dimensions does not contain its own dimensions. Mapping does not take place for the columns available in fact tables. The values in the table is neither dimensions nor measures.

What is degenerate dimension table?

A degenerate table does not have its own dimension table. It is derived from a fact table. The column (dimension) which is a part of fact table but does not map to any dimension.
e.g. employee_id
Data warehousing - What is Data Mart?
What is Data Mart? - Data Mart is a data repository which is served to a community of people......
Data warehousing - difference between metadata and data dictionary
Difference between metadata and data dictionary - Metadata describes about data. It is ‘data about data’. It has information about how and when......
Data warehousing - various methods of loading Dimension tables.
Various methods of loading Dimension tables - The following are the methods of loading dimension tables........
Post your comment