Conformed Dimension

Conformed Dimension - A dimension that is used in more than one cube. The use of conformed dimensions and shared measures is the primary way a set of data marts can be united into one consolidated data warehouse. 

[Category=Data Warehousing ]

Source: SDG Computing Inc., 05 May 2010 08:50:06, SDG Computing, now offline

---

These advertisers support this free service

---

Conformed Dimension - A dimension that has exactly the same meaning and content when being referred from different fact tables.

[Category=Data Warehousing ]

Source: Aexis Business Intelligence, 13 November 2010 07:29:51, http://www.aexis.eu/DataWarehouse-Glossary/

---

conformed dimension - In data warehousing, a conformed dimension is a dimension that has the same meaning to every fact with which it relates. Conformed dimensions allow facts and measures to be categorized and described in the same way across multiple facts and/or data marts, ensuring consistent reporting across the enterprise.

A conformed dimension can exist as a single dimension table that relates to multiple fact tables within the same data warehouse, or as identical dimension tables in separate data marts. Date is a common conformed dimension because its attributes (day, week, month, quarter, year, etc.) have the same meaning when joined to any fact table. A conformed product dimension with product name, description, SKU, and other common attributes could exist in multiple data marts, each containing data for one store in a chain.

Related glossary terms: data modeling / data modelling, star schema, dimension, snowflaking (snowflake schema), predictive modeling

[Category=Data Management ]

Source: WhatIs.com, 14 July 2013 09:11:08, http://whatis.techtarget.com/glossary/Data-and-Data-Management