Question
How should several low-cardinality transaction flags such as promotion type, gift-wrap flag, and order channel often be modeled?
Select an option. Your answer will be checked instantly.
Correct Answer: B. Combine them into a junk dimension
Explanation:
A junk dimension groups miscellaneous small categorical attributes.
It avoids cluttering the fact table with many separate indicator columns.
Leave a Reply