ETL vs. ELT in a Parallel Data Warehouse
Traditionally we have been doing ETL; extract of the data from the source systems, then transforming it to fit our needs, and finally loading them into the end target such as a fact table.
However, in the world of Massive Parallel Processing (MPP) scale out data warehousing, can this approach still be used?
Some advocate the ELT approach instead, which extract the source data, then load it into the end target, and finally do the transformations at the data in the target. But what are the benefits of this? And does it really matter?
This session tries to answer these questions by looking at the difference between the ETL and ELT approach, and how SSIS can be used with a Parallel Data Warehouse.
Sorry, there are no downloads available for this session.
David Peter Hansen is a BI Technical Solution Lead at Maersk Line, the world largest shipping company. He has worked with database development and administration for 12 years, and has worked with the Microsoft Business Intelligence platform since SQL Server 2000. He specialises in developer coaching as well as scalable architecture and performance tuning on large-scale data warehouses and BI solutions.
The video is not available to view online.
- Session Files Explorer
The network name cannot be found.