Question: In a dimensional model, I have an indicator flag with possible values Y or N. This is not related to any of the dimension tables. Can I put these indicators in the fact table? Would you advise creating a junk dimension for a single flag? Also, when is it a good idea to create a junk dimension table i.e., approximately how many flags should we have before we decide to use a junk dimension table?
Register or login for access to this item and much more
All Information Management content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access