This is regarding the term called SCD which stands for Slowly Changing
Dimensions.
Dimension is a term in data management and data ware housing that refers
to logical groupings of data such as geographical location, customer
information, or product information. Slowly Changing Dimensions (SCD)
are dimensions that have data that slowly changes.
For example, you may have a Dimension in your database that tracks the
sales records of your company's salesmen. Creating sales reports seems
simple enough, until a sales person is transferred from one regional
office to another. How do you record such a change in your sales
Dimension?
There are several types of SCDs
You can have more details on this through the following link.
http://en.wikipedia.org/wiki/Slowly_Changing_Dimension
No comments:
Post a Comment