DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
When they can be compared mathematically
|
|
When they can be compared mathematically
|
|
When they have different values
|
|
When they are labelled differently
|
Detailed explanation-1: -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.
Detailed explanation-2: -Conformed dimensions are dimensions that are shared by multiple stars. They are used to compare the measures from each star schema [3]. The reuse of conformed dimensions is very common in order to “support true, cross-business process analysis” [6].
Detailed explanation-3: -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.
Detailed explanation-4: -Everything around us, from the houses we live in to the objects we use in everyday life, has three dimensions: height, length, and width.
Detailed explanation-5: -Conformed vs Role-Playing Dimension Conformed is the same dimension used in different facts and has the same meaning ex: CustomerID. Role-Playing is the same dimension which used multiple times within the same fact but with different meanings ex: Date.