Saved Bookmarks
| 1. |
What Is Degenerated Dimension? |
|
Answer» A DEGENERATED DIMENSION is a dimension that is DERIVED from fact table and does not have its own dimension table. A dimension key, such as transaction number, receipt number, Invoice number etc. does not have any more associated attributes and HENCE can not be designed as a dimension table. A degenerated dimension is a dimension that is derived from fact table and does not have its own dimension table. A dimension key, such as transaction number, receipt number, Invoice number etc. does not have any more associated attributes and hence can not be designed as a dimension table. |
|