Data Architect Question:
Download Job Interview Questions and Answers PDF
Do you know what is junk dimension?
Answer:
A junk dimension is a grouping of typically low-cardinality attributes (flags, indicators etc.) so that those can be removed from other tables and can be junked into an abstract dimension table.
These junk dimension attributes might not be related. The only purpose of this table is to store all the combinations of the dimensional attributes which you could not fit into the different dimension tables otherwise. Junk dimensions are often used to implement Rapidly Changing Dimensions in data warehouse.
These junk dimension attributes might not be related. The only purpose of this table is to store all the combinations of the dimensional attributes which you could not fit into the different dimension tables otherwise. Junk dimensions are often used to implement Rapidly Changing Dimensions in data warehouse.
Download Data Architect Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Tell me what is Fact? | Can you throw some light on your experience in Data Modelling with respect to projects you have worked on till date? |