Dimension tables are collection of dimensions or information about attributes available in fact table. A dimension attribute provide meaning to a fact. Without dimension tables facts are meaning less. Its attributes also used to views fact data at different level(or summarize data at different level of an organizational hierarchy).
Following are the types of dimension tables:
  1. Slowly Changing Dimension
  2. Rapidly Changing Dimension
  3. Junk Dimension
  4. Inferred Dimension
  5. Confirmed Dimension
  6. Role Playing Dimension
  7. Shrunken Dimension
  8. Static Dimension
  9. Degenerate Dimension
Leave A Comment

Please login to post your valuable comments.

Join the newsletter

Get the latest vLemonn news first