Tag Archives: ETLT

Why is ETL a four-letter word?

ETL (Extract-Transform-Load) technology has been around for over a decade, and while it rocked the world in the 90′s, it’s considered a bit of a relic nowadays. Data warehousing, the original driver for ETL technology, isn’t considered as sexy anymore. That’s in part why vendors have used different names to broaden this software category and added new capabilities to keep it relevant.

Informatica is no exception. We’re “the Data Integration Company“, where data integration consists of many different capabilities, only one of which is ETL (granted, the ETL piece is the cornerstone for data warehousing and other data integration projects).

And the letters E-T-L themselves have been put in the blender to be reconfigured into newer, fresher concepts. ELT or ETLT incorporates the concept of pushdown optimization, where processing is handled in the database, instead of the ETL server. (For more detail, Rajan Chandras has a good post discussing ETL vs. ELT.) ETQL pulls data quality into the ETL workflow. And I’m sure the permutations will continue.

So, is classic ETL just not relevant anymore? (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Data Integration, Data Warehousing | Tagged , , , , | Leave a comment