Multiple choice technology

Casual dimensions can be used

  1. As a helper table

  2. For explaining why a record exists in a fact table

  3. For integrating data marts into a data warehouse

  4. For handling changes to the data
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Casual dimensions (also called degenerate dimensions) are dimension attributes stored in the fact table that have no corresponding dimension table. They explain why a fact exists - such as invoice number, order number, or transaction ID - and provide context without requiring a separate dimension table.

Keep practicing — related questions