Page 3 of 3 • 1, 2, 3
- Aditya992000
- Posts : 9257
Join date : 2019-01-07
Re: What are Dimensions ?
Mon Jan 14, 2019 11:38 am
A conformed dimension is a set of data attributes that have been physically referenced in multiple database tables using the same key value to refer to the same structure, attributes, domain values, definitions and concepts. A conformed dimension cuts across many facts.
- Aditya992000
- Posts : 9257
Join date : 2019-01-07
Re: What are Dimensions ?
Mon Jan 14, 2019 11:38 am
Dimensions are conformed when they are either exactly the same (including keys) or one is a perfect subset of the other. Most important, the row headers produced in two different answer sets from the same conformed dimension(s) must be able to match perfectly.
- Aditya992000
- Posts : 9257
Join date : 2019-01-07
Re: What are Dimensions ?
Mon Jan 14, 2019 11:38 am
Conformed dimensions are either identical or strict mathematical subsets of the most granular, detailed dimension. Dimension tables are not conformed if the attributes are labeled differently or contain different values. Conformed dimensions come in several different flavors.
- Aditya992000
- Posts : 9257
Join date : 2019-01-07
Re: What are Dimensions ?
Mon Jan 14, 2019 11:39 am
At the most basic level, conformed dimensions mean exactly the same thing with every possible fact table to which they are joined. The date dimension table connected to the sales facts is identical to the date dimension connected to the inventory facts.
Page 3 of 3 • 1, 2, 3
Permissions in this forum:
You cannot reply to topics in this forum
|
|