SQLBits 2011

Implementing Real-Time Data Warehouse

Steps involved in implementing a near-real-time data warehousing solution.
In this session I will be demonstrating how easy is to implement a near-real-time data warehousing solution. I am going to talk you through a scenario where we have to load 2000 source files every 15 mins. Users want to see that 2000 files aggregated data in the dashboard before next 2000 file arrives. How quickly can we do it? What steps and best practices should be followed when implementing real-time data warehousing solutions.