Intelligent ETL with SQL Server


Presenter: Jyoti Gupta

Session Details


Many developers are tasked with moving and transforming data stored in SQL Server tables. In this hour-long seminar, developers will explore techniques for building intelligent ETL applications for SQL Server that maximize their productivity and accuracy. We will focus on reusability via bottom-up development of ETL applications. We will start with understanding how to introduce reusability into the ETL design process and then study reusable design components, such as metadata structures and connectivity information. Finally, we'll build a small application that takes advantage of reusable design sub-components. A brief Q/A session will end the seminar.


About the Speaker


Jyoti Gupta is a senior field engineer for expressor, a software company that provides free ETL software for extracting and loading SQL Server data. She has 10 years of experience in Data Integration/ETL, starting as a field engineer for Torrent Systems, where the current parallel ETL engine from DataStage originated. Since Torrent Jyoti has worked in a variety of vertical markets, implementing data warehouses and data-driven technology systems. Prior to joining expressor, Jyoti was a technical trainer for IBM, specializing in the InfoSphere product suite.



Copyright 2013 by PASS | Terms of Use | Privacy | Login