|
Answer» There are 5 types of DIMENSIONS, they are: - Conformed dimension: These are the dimensions that are used in MULTIPLE tables in a database by allowing measures and FACTS to be categorized and described consistently across other facts or data marts.
- Junk dimension: Here the ATTRIBUTES do not belong to the fact table or any existing dimension table. They are USUALLY text or are like flags indicating ‘Y’ or ‘N’ (yes or no) or true or false.
- Role-playing dimension: Here, there are multiple relationships valid between itself and other tables. It is used for deciding how the roles can be used with other facts which do not share the same concepts.
- Slowly changing dimension: These have attributes that change over time and also include dimensions where data is preserved or replaced in history.
- Degenerated dimension: These dimensions do not have their dimension tables but are part of the primary key in the fact table.
|
