Data warehousing junk dimension: What is junk dimension?

What is junk dimension?

In scenarios where certain data may not be appropriate to store in the schema, this data (or attributes) can be stored in a junk dimension. The nature of data of junk dimension is usually Boolean or flag values.

e.g. Whether the performance of employee was up to the mark?, Comments on performance.

What is junk dimension?

A single dimension is formed by lumping a number of small dimensions. This dimension is called a junk dimension. Junk dimension has unrelated attributes. The process of grouping random flags and text attributes in dimension by transmitting them to a distinguished sub dimension is related to junk dimension.
Data warehousing: What are fundamental stages of Data Warehousing?
What are fundamental stages of Data Warehousing? - Stages of a data warehouse helps to find and understand how the data in the warehouse changes..........
Data warehousing - What is Virtual Data Warehousing?
What is Virtual Data Warehousing? - The aggregate view of complete data inventory is provided by Virtual Warehousing.........
Data warehousing - What is active data warehousing?
What is active data warehousing? - The transactional data captured and reposited in the Active Data Warehouse........
Post your comment