Geeks With Blogs
Random Musing Putting it together one piece at a time... September 2007 Entries
Designing for Slowly Changing Dimension and Rapid Changing Dimensions
SCD (Slow Changing Dimension) has been a very common scenario for data warehouses and there are many established and proven techniques that can be used to solve the problems. This includes the usage of SCD Type II (Insert only) or SCD Type I (Update only) methodology. When we start to look at designing a system that caters for real time information, it's very common that we will meet the same problems, with the exception that the dimension doesn't change slowly, but rapidly. Moreover, they normally ......

Posted On Monday, September 3, 2007 9:34 AM

Copyright © Nestor | Powered by: