Implementing Real-Time Data Warehouse
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.
I have been working with SQL Server for last 11 years. Predominantly I spent most of my carrier building data warehouses and loading the data using various ETL Tools such as DTS, SSIS, Ab-Initio and Informatica. I have work for well known brands such as Tyco and Reuters before joining Hitachi Consulting. I have got MBA in Project Management, MCITP-BI (2005 & 2008) & MCDBA. I have worked in diverse business sectors such as Financial Services, Media, Share Market Data, Mergers and Acquisition, Pub Management, Security, Building Society, Bank, Mortgages, Publishing and Commercial Finance.