Data Architect Question:

Download Job Interview Questions and Answers PDF

Explain me what is a 'Conformed Dimension'?

Data Architect Interview Question
Data Architect Interview Question

Answer:

A conformed dimension is the dimension that is shared across multiple subject area. Consider 'Customer' dimension. Both marketing and sales department may use the same customer dimension table in their reports. Similarly, a 'Time' or 'Date' dimension will be shared by different subject areas. These dimensions are conformed dimension.

Theoretically, two dimensions which are either identical or strict mathematical subsets of one another are said to be conformed.

Download Data Architect Interview Questions And Answers PDF

Previous QuestionNext Question
Do you know what do you understand by Data Modelling?Tell me additive Measures?