Data Architect Question:

What are conformed dimensions?

Data Architect Interview Question
Data Architect Interview Question

Answer:

A Dimension that is utilized as a part of different areas is called as conformed dimension. It might be utilized with different fact tables in a single database or over numerous data marts/warehouses. For example, if subscriber dimension is connected to two fact tables – billing and claim then the subscriber dimension would be treated as conformed dimension.


Previous QuestionNext Question
Explain me what do you understand by data mart?Tell me what is a fact & a fact table?