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.

Speaker

I have been working with SQL Server for last 12 years. Predominantly I spent most of my carrier building data warehouses and loading the data using various ETL Tools such as SSIS, Ab-Initio and Informatica. I specialise in financial services sector.

Sutha Thiru's Sessions

Implementing Real-Time Data Warehouse