HomeData warehouseDifference between ETL and ELT

Comments

Difference between ETL and ELT — 13 Comments

  1. We largely use ELT in large part so that we have the unaltered data in our database for reference if there are any problems that need troubleshooting.

    What I don’t like about ETL is that detecting errors can be more difficult, and then fixing them can be even more difficult because this may require modifications to SSIS packages or other such things.

    I prefer to have the load process as “dumb” as possible, just load EXACTLY what is in the file into the database, change NOTHING. Then, once in the database, its easier to see the data, profile the data, make assessments and in the even of unexpected data, address it as needed instead of having largely hidden processes dealing with it.

    I will say though that we deal largely with custom data loads, for a data feed that is well defined and consistent, then ETL makes more sense. When loading “new” data, or data from new sources, etc., I prefer ELT.

  2. Pingback:Comparison between ETL and ELT « BLOGGERZSPOT.COM

  3. Pingback:ETL or ELT… or both?? | Microsoft OLAP Blog

  4. Hi,
    Many other sources tell me exact opposite of the definitions you’ve provided above.. can you please elaborate? What I know and read in multiple posts, that ETL is about “Extracting data from source systems” , landing data in staging, then performing some “Transformations” and finally “Loading into target system”.
    While ELT is when data is “Extracted from source systems”, and directly “Loaded to target system” and “Transformations” are applied there..
    Please let me know if you meant the same or I’m missing something?

    Thanks & Regards.

  5. Pingback:ETL or ELT… or both?? « ORAYLIS Blog

  6. Pingback:ETL or ELT… or both?? |

  7. Pingback:Big Data Architectures | James Serra's Blog

  8. Pingback:Integration Services Performance Best Practices – Writing to the Destination – My Blog

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>