JAN 18, 2013 9:24am ET

Related Links

BI Reference Architecture that Actually Works
6 Trends Guiding Financial Customer Data

Web Seminars

Essential Guide to Using Data Virtualization for Big Data Analytics
September 24, 2014
Integrating Relational Database Data with NoSQL Database Data
October 23, 2014

ETL to ELT Conversion Testing in Data Warehouse Engagements


With the ever changing business environment and an extremely volatile economy, the financial services and the banking industries are facing acute challenges in quickly generating proficient analytical information/reports through data warehousing, which enables businesses to make informed decisions.

Get access to this article and thousands more...

All Information Management articles are archived after 7 days. REGISTER NOW for unlimited access to all recently archived articles, as well as thousands of searchable stories. Registered Members also gain access to:

  • Full access to information-management.com including all searchable archived content
  • Exclusive E-Newsletters delivering the latest headlines to your inbox
  • Access to White Papers, Web Seminars, and Blog Discussions
  • Discounts to upcoming conferences & events
  • Uninterrupted access to all sponsored content, and MORE!

Already Registered?


Comments (1)
Hi Sundaresa-

Very interesting article. I would like to offer another perspective. I've encountered many organizations that have pulled the transformations (ETL) out of their ETL layer or tool and pushed the transformations into the warehouse (ELT) because the ETL layer could not perform or scale to the needs of the business (e.g., meet their SLA for instance).

Many tools/vendors even "promote" this with so called push down "optimization" capabilities to generate the SQL that creates the ELT or ETLT. What's needed is a high performance, scalable tool that can intelligently and automatically scale to the requirements and data volume required.

I also think this is why many organizations are also looking at Hadoop. Very common use cases for Hadoop is ETL. There are many articles from both organizations and the Hadoop vendors talking about ETL uses in Hadoop. The issue here is not necessarily one of scale, but the maturity (or really the immaturity) of both Hadoop and MapReduce skill sets.

Thanks again for a very interesting article.

--Keith Kohl

Posted by Keith K | Saturday, January 19 2013 at 12:03PM ET
Add Your Comments:
You must be registered to post a comment.
Not Registered?
You must be registered to post a comment. Click here to register.
Already registered? Log in here
Please note you must now log in with your email address and password.
Login  |  My Account  |  White Papers  |  Web Seminars  |  Events |  Newsletters |  eBooks
Please note you must now log in with your email address and password.