Data Warehouse Developer Question:
Download Job Interview Questions and Answers PDF
Explain me what is junk dimension?
![Data Warehouse Developer Interview Answer Data Warehouse Developer Interview Question](https://globalguideline.com/public/images/interview/9.webp)
Answer:
☛ 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.
☛ 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.
☛ 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.
Download Data Warehouse Developer Interview Questions And Answers
PDF
Previous Question | Next Question |
Tell us what is snapshot with reference to data warehouse? | Please explain what is VLDB? |