Conformed Dimensions (CD): these dimensions are something that is built once in your model and can be reused multiple times with different fact tables.
For example, consider a model containing multiple fact tables, representing different data marts. Now look for a dimension that is common to these facts tables. In this example let’s consider that the product dimension is common and hence can be reused by creating short cuts and joining the different fact tables.Some of the examples are time dimension, customer dimensions, product dimension.
No comments:
Post a Comment