Session

Back

ETL Confessions

Date: 2017-09-08
Time: 10:30 - 11:20
Room: Mission
Level: Intermediate

ETL, Extract Transform and Load, is the name given to operations which bring data from OLTP systems and other third party systems into data warehouses.

This talk examines a few common problems encountered in ETL operations: data format discovery, data loading, and progressive aggregation. For each problem, I show a few common practices, discuss the resource profiles of those practices, and attempt to benchmark them against some more creative solutions.

Speaker

Corey Huinker