WLG ODC Day 2017 has ended
Back To Schedule
Monday, November 20 • 12:05 - 12:50
What The ETL is Going On with Peter Scott

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Why is my ETL slow? This light-hearted presentation looks at some the misguided techniques developers have chosen to fulfil the functional requirements of their ETL processes but forgetting the need for the ETL to run quickly and efficiently. Looking at various examples I have seen in both hand-coded SQL and integration tools such as Oracle Data Integrator I look at the problems of doing too much work in a process. Sometimes through writing our own code to do something the platform does natively, other times through just moving too much data around. The presentation will look at: - using the in-built functionality of the platform and not writing your own; - doing things at the right time and place; - choosing techniques appropriate for the platform; - why correct data types are important; - the dangers of doing too much work. At the end of the talk developers should smile at the misfortune of others, but also have a renewed knowledge of appropriate techniques in ETL

avatar for Peter Scott

Peter Scott

Peter is an Oracle ACE with almost 20 years experience of designing and building large scale data warehousing and business intelligence solutions. He specialises in data warehouse performance optimisation, ETL design and data quality improvement.In past roles Peter has worked for... Read More →

Monday November 20, 2017 12:05 - 12:50 NZDT