Explain conformed fact?



Explain conformed fact?..

Answer / Ajay Rametkar

A Conformed Fact refers to the common set of facts that are shared across multiple data marts in a data warehouse. It represents the same business events and measurements, allowing for easy integration and analysis of data from different areas of the business.nnBy defining conformed facts, you ensure consistency in the definition, granularity, measurement units, and timestamps of your data across all data marts.nnFor example, if multiple data marts have sales data, they will use a single, consistent definition for 'sales' instead of each mart having its own unique definition.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE

1 Answers   Wipro,


How to stop a batch?

1 Answers  


How can we do data cleaning?

1 Answers  


Explain some of modeling tools available in the market?

1 Answers  


Explain what are the steps to build the data warehouse?

1 Answers  


Explain what is type 2 version dimension?

1 Answers  


What is metadata in context of a datawarehouse?

1 Answers  


Explain bus schema?

1 Answers  


Hi,Please can u tell me.. What is the difference between a Hyperion Essbase CUBE and a Star Schema? Thanks in advance, Vijay.

1 Answers   iFlex, Wipro,


What is application.cfm?

1 Answers  


What is Discover and Execute in XMLA?

1 Answers  


what type of raid setup would you put your tx logs?

1 Answers  


Categories