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

Don't have an account? Register for Free Unlimited Access