The Slowly Changing Dimension problem is a common one particular to data warehousing.There are in general three ways to solve this type of problem, and they are categorized as follows:
- Type 1: The new record replaces the original record. No trace of the old record exists. Read more
- Type 2: A new record is added into the customer dimension table.Thereby, the customer is treated essentially as two people. Read more
- Type 3: The original record is modified to reflect the change. Read more
If you like this post, please share it on google by clicking on the Google +1 button.
Please go through our latest post TOP6 BIG DATA TRENDS IN THE NEAR FUTURE