We’ve added another new session to our upcoming WWDVC conference! We want to welcome Kent Graziano to our conference. Here’s a sneak peek at what he will be engaging you with:
Agile Data Warehousing: Using DV 2.0 Concepts to Build a Virtualized ODS
At a past client, to meet project timelines to fulfill urgent, unmet reporting needs, I found it necessary to build a virtualized Operational Data Store as the first phase of a new Data Vault 2.0 project. This allowed me to deliver new objects, quickly and incrementally to the report developer so we could quickly show the business users their data. In order to limit the need for refactoring in later stages of the data warehouse development, I chose to build this virtualization layer on top of a Type 2 persistent staging layer. All of this was done using a MS SQL Server Database. In this talk I will show you the architecture for this approach, the rationale, and then the tricks I used views very quickly. In the end you will see actual SQL code for a virtual ODS.
You WON’T Want to miss this years’ conference. If you haven’t registered yet, please do so today – just click the link below.
See you at #WWDVC – the best and ONLY authoritative #datavault conference in the world.