by marcos | Jun 4, 2012 | In2BI
Type 2 Loading is a pattern that is often used to incrementally load dimensions in a data warehouse. But you can also use it for loading satellites in a data vault or loading tables in a historical/persistent staging area. It consist of three parts: Identify new rows...
by marcos | May 14, 2012 | In2BI
The requirements of a Data Warehouse solution continually change during its life time. For some organizations you’ll typically expect more changes than others. Think of maturity, history of organizational changes: mergers, acquisitions etc. You should adopt a solution...
by marcos | Sep 5, 2011 | In2BI
A lot of emphasis on the Internet lately has been placed on the difference between both methods. This blogpost from Dan Linstedt and this discussion on the Kimball forums are examples of this strange focus. A focus I don’t totally understand since both techniques...
