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.
|