Sunday, January 27, 2013

Difference between ETL and ELT

When interviewing for a BI job, you may get asked the tricky question, "What is the difference between ETL and ELT?"

Both are acronyms for a process that leads to the same result. ETL stands for Extract/Transform/Load while ELT is Extract/Load/Transform. You accomplish the same thing but do activities in a slightly different sequence. Your interviewer is going to want you to explain WHY.

For a nice explanation, see this Data Academy white paper.

1 comment:

Web Developers in Bangalore said...

Here only i knew the difference between ETL and ELT.I am very glad to you for your well information.
Web Developers in Bangalore

About Me

My photo

I am a project-based consultant, helping data-intensive firms use agile methods and automation tools to replace legacy reporting and bring in modern BI/Analytics to leverage Social, Cloud, Mobile, Big Data, Visualizations, and Predictive Analytics. For several world-class vendors, I led services teams specializing in providing software implementation and custom application development. Based on scores of successful engagements, I have assembled proven methodologies and automated software tools.

During twenty years of technical consulting, I have been blessed to work with smart people from some of the world's most respected organizations, including: FedEx, Procter & Gamble, Nationwide, The Wendy's Company, The Kroger Co., JPMorgan Chase, MasterCard, Bank of America Merrill Lynch, Siemens, American Express, and others.

I was educated at Valparaiso University and the University of Cincinnati, graduating summa cum laude. In 1990, I joined Information Builders, the vendor of WebFOCUS BI and iWay enterprise integration products, and for over a dozen years served in branch leadership roles. For several years, I also led technical teams within Cincom Systems' ERP software product group and the custom software services arm of Xerox.

Since 2007, I have provided enterprise BI services such as: strategic advice; architecture, design, and software application development of intelligence systems (interactive dashboards and mobile); data warehousing; and automated modernization of legacy reporting.