Explain me what is junk dimension?
Submitted by: Muhammad☛ 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.
Submitted by: Muhammad
☛ 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.
Submitted by: Muhammad
Read Online Data Warehouse Developer Job Interview Questions And Answers
Top Data Warehouse Developer Questions
☺ | Explain me why is chameleon method used in data warehousing? |
☺ | Tell us what is Hybrid SCD? |
☺ | Tell us what is the main difference between Inmon and Kimball philosophies of data warehousing? |
☺ | Can you list the Schema that a data warehouse system can implements? |
☺ | Tell us what is Virtual Warehouse? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |