Post reply

ELT vs ETL

  • May 19, 2006 at 11:15 am

    #172573

    Actaully ELT and ETL are different.

    ELT - extract, loading and transform

    ETL - extract, transform and loading.

    It is differenet in these days.   ELT loads data into the database and then finds which record has problem and change it. ETL actally  cleanse the data before it loads into the database.

    Which one would you prefer?

     

  • May 19, 2006 at 12:05 pm

    #639072

    It depends. ETL is much faster and can handle much more complex logic. DTS (now renamed SSIS I think) are specialized for it.

    ELT is a good choice when the amonount of data and transaformations is not too large. Use a secondary database (you don't want to be in full log mode usually if you are batch 10 millions rows).

    When the job is simple, I go the ELT way. If it is complex, or prone to become complex in the future, I use ETL. One of the reasons is that I hate the DTS UI. SSIS is much improved but I haven't worked with it yet.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply