Don't Push ELT Around

Recently I ran into this article entitled: ELT vs. ETL: Much Ado about Something .

Yes. Yet another ETL vs. ELT blog.

I just couldn't help myself writing something. I would agree with the assessment that "There's no doubt that ELT is now a mainstream capability" ... now the only disagreement is on the how. I would disagree that the term push-down is the only mechanism for ELT; in fact there are multiple approaches.

Some solutions use a push-down approach, what I like to call "ETLT" (a pushdown of the transformation after the fact) while others natively run transforms on the target systems. There's certainly advantages to running optimizations directly on the target system natively without the overhead of having to do the conversions.

As data warehouses, business intelligence applications, yearn for real-time capabilities, the low latency requirements for these systems becomes paramount. This is especially true for data warehouse appliances that are designed to take full advantage of these types of native ELT approaches.

So I hope we are all in agreement that ELT is the right path. Send me your views if you agree or disagree on the how.

Comments:

In two bullet points: - ELT is an well-designed architecture. - Pushdown in an ETL engine is an "afterthought".

Posted by FX on August 31, 2008 at 11:56 PM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
5
6
7
8
9
10
12
13
14
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today