Tell me what are the different types of dimension?
Submitted by: MuhammadIn a data warehouse model, dimension can be of following types,
☛ Conformed Dimension
☛ Junk Dimension
☛ Degenerated Dimension
☛ Role Playing Dimension
Based on how frequently the data inside a dimension changes, we can further classify dimension as
☛ Unchanging or static dimension (UCD)
☛ Slowly changing dimension (SCD)
☛ Rapidly changing Dimension (RCD)
Submitted by: Muhammad
☛ Conformed Dimension
☛ Junk Dimension
☛ Degenerated Dimension
☛ Role Playing Dimension
Based on how frequently the data inside a dimension changes, we can further classify dimension as
☛ Unchanging or static dimension (UCD)
☛ Slowly changing dimension (SCD)
☛ Rapidly changing Dimension (RCD)
Submitted by: Muhammad
Read Online Data Architect Job Interview Questions And Answers
Top Data Architect Questions
☺ | Tell me do you know why Data Warehouse is used? |
☺ | Explain me what do you understand by data mart? |
☺ | What are conformed dimensions? |
☺ | Tell me what is a fact & a fact table? |
☺ | Tell me the physical data model? |
Top Data Structure Categories
☺ | Data Center Manager Interview Questions. |
☺ | Creative UI/UX Designers Interview Questions. |
☺ | Sort And Searching Interview Questions. |
☺ | Data Structure Linked list Interview Questions. |
☺ | Data Structure Arrays Interview Questions. |