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 software consultant, specializing in automating transitions from legacy reporting applications into modern BI/Analytics to leverage Social, Cloud, Mobile, Big Data, Visualizations, and Predictive Analytics using Information Builders' WebFOCUS. Based on scores of successful engagements, I have assembled proven Best Practice methodologies, software tools, and templates.

I have been blessed to work with innovators from firms such as: Ford, 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, where I graduated summa cum laude. In 1990, I joined Information Builders and for over a dozen years served in regional pre- and post-sales technical leadership roles. Also, for several years I led the US technical services teams within Cincom Systems' ERP software product group and the Midwest 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. My experience with BI products include WebFOCUS (vendor certified expert), R, SAP Business Objects (WebI, Crystal Reports), Tableau, and others.