Layered Partitioning - (re)load your data fast

Loading data into your Data Warehouse is not always a trivial task. Especially if the source systems can re-deliver data and you want to replace an old subset of your data. The quick answer you always hear is “just use partitioning”, but nobody really tells you how you should design or implement it. This session will show one way to load and access your data really fast, by using layered partitioning. We will walk through partitioned tables and partitioned views, before moving on to the concept of layered partitioning. We will also take a look at the management and performance benefits (and challenges) partitioning gives us.