Data Warehouse Developer Question:

Download Job Interview Questions and Answers PDF

Explain me what is junk dimension?

Data Warehouse Developer Interview Question
Data Warehouse Developer Interview Question

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.

Download Data Warehouse Developer Interview Questions And Answers PDF

Previous QuestionNext Question
Tell us what is snapshot with reference to data warehouse?Please explain what is VLDB?