|
Conformed dimensions help in making the data-warehouse as
- Scaleable (can add more volumes of data)
: The whole ETL process will be more efficient as it
does not have to do multiple processes to process the same dimensions
related data (for example customer data) more than once.
-
Extensible (add more attributes to a dimension or add
more facts to the fact table): If there is one customer dimension, it allows the whole
process of changing the dimensional attributes easy and less complex.
It will have minimal impact on the queries and associated meta-data, reports
& views built on the dimension. In-short more different versions of a
dimension, as much more work one needs to do to handle any change.
-
Flexible (allowing more of ad hoc and unplanned queries): As mentioned in another field tip "Conformed dimensions
are must for cross-drilling ", the joins across multiple fact tables are
possible to be done easily if the dimensions in those fact tables are
conformed.
|
