JAN 18, 2013 9:24am ET

Related Links

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

Web Seminars

Advancing Analytics in the Digital Age
Available On Demand
The Real Cost of “Chat Now” for Your Business
July 29, 2014
Feature

ETL to ELT Conversion Testing in Data Warehouse Engagements

Print
Reprints
Email

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?

Advertisement

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.
Twitter
Facebook
LinkedIn
Login  |  My Account  |  White Papers  |  Web Seminars  |  Events |  Newsletters |  eBooks
FOLLOW US
Please note you must now log in with your email address and password.