SQL provides many ways to move data from an OLTP source system to a data warehouse server, however choosing the most efficient and scalable ETL solution can be challenging. Various ETL architectures will be explored by analyzing their strengths and weaknesses with data warehouse workloads. Best practices based on having developed ETL systems that load 1+ TB/hr. will be presented.
MCITP, MCSE with over 10 years of experience working with Microsoft BI Stack. He has worked as consultant in wide range of industries, with the last 5 of years focused Microsoft’s Parallel Data Warehouse and Fast Track Appliances for large scale data warehouses into the hundreds of terabytes.