Data warehousing - What is conformed fact? What is conformed dimensions use for?

What is conformed fact? What is conformed dimensions use for?

Allowing having same names in different tables is allowed by Conformed facts. The combining and comparing facts mathematically is possible. A dimensional table can be used more than one fact table is referred as conformed dimension. It is used across multiple data marts along with the combination of multiple fact tables. Without changing the metadata of conformed dimension tables, the facts in an application can be utilized without further modifications or changes.

What is conformed fact? What is conformed dimensions use for?

Conformed fact in a warehouse allows itself to have same name in separate tables. They can be compared and combined mathematically. Conformed dimensions can be used across multiple data marts. These conformed dimensions have a static structure. Any dimension table that is used by multiple fact tables can be conformed dimensions.
Data warehousing - Define non-additive facts
Define non-additive facts - The facts that can not be summed up for the dimensions present in the fact table are called non-additive facts......
Data warehousing - Define BUS Schema
Define BUS Schema - A BUS schema is to identify the common dimensions across business processes......
Data warehousing - List out difference between SAS tool and other tools.
Difference between SAS tool and other tools - The differences between SAS and other tools are......
Post your comment