me,myself,english and programming..
«
»

Extract, Transform and Load (ETL)

My day to day job is all about ETL . Currently i need to load a full refresh data from AS400 source system into Data Warehouse system in SQL Server.

Basically,you can imagine how this works using below diagram.

ETL Diagram

source: http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=89534

For all these, im using ADT. For me,ADT is a powerful CA product. Using it, you can move your data from any source to anywhere,anytime and the most important thing is, it’s very easy to use. :D

Below is a simple transformation that we can do.

simple test

Well,that’s for introduction. :D

Till then…

This entry was posted on Friday, November 3rd, 2006 at 12:18 am and is filed under SQL/ETL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

  1. 7 Responses to “Extract, Transform and Load (ETL)”

  2. By gerg on Nov 3, 2006 | Reply

    ini ek kije ko .. heheh.. ok lah tu :D .. aku tatau apa kebenda yang ko duk citer tu .. anyway thanks .. ada benda baru aku blaja ari nih ehehe

  3. By arejae on Nov 3, 2006 | Reply

    ehee…iniler kejer aku sekarang gerg.since 2002 lagi.semua main drag and drop jer. ada sket2 jer programming.

  4. By gerg on Nov 3, 2006 | Reply

    ehhee kira nya db admin laa ni ek?

  5. By arejae on Nov 6, 2006 | Reply

    tak juga gerg.
    tapi more on datawarehouse punya stuff lar.

  1. 3 Trackback(s)

  2. Nov 6, 2006: Business Intelligence Arejae.Com | Jom Belajar Programming
  3. Jun 30, 2008: Extract, Transform and Load (ETL) - Part 2 | Arejae.Com
  4. Oct 25, 2008: Pentaho Data Integration - Introduction | Arejae.Com

Post a Comment