ETL Sample Query
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: ETL Sample Query

  1. #1
    Join Date
    Oct 2000
    Posts
    449

    ETL Sample Query

    Hi.. I want to know how ETL works.. I have read a few articles etc., but can anyone show me in code what ETL is.. There could be many tools, but I want to know how it is done manually..

    Identify a table, extract to flatfiles, transform and load..

    If anyone can point me to the right place on the web that's fine too..

    Thanks, ST2000

  2. #2
    Join Date
    Mar 2002
    Posts
    200

    Re: ETL Sample Query

    Originally posted by st2000
    ..but can anyone show me in code what ETL is
    Thanks, ST2000

    ETL is not something one can show "in" code as you have put. ETL is a concept of transforming data (generally OLTP data or Flat File data) that adheres to a Data Warehouse Model.

    Using Tools to achive this is easiest, specially "Informatica". If you don't want to use any tools, you can write PL/SQL Stored Procedures and tranform and load the data. It depends what your "transformation logic" is, which is derived from your business requirements.

    Since your fundas doesn't seem clear enough, I suggest you start looking into basic Data Warehosuing concepts..you will get plenty of material if you search on Google.

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: ETL Sample Query

    Originally posted by st2000
    Hi.. I want to know how ETL works.. I have read a few articles etc., but can anyone show me in code what ETL is.. There could be many tools, but I want to know how it is done manually..

    Identify a table, extract to flatfiles, transform and load..

    If anyone can point me to the right place on the web that's fine too..

    Thanks, ST2000
    ETL as such is a concept......as quester said.....

    Informatica is a ETL tool & the code of which u cant get......
    Even if u get by any chance( If u know the guys who have developed )
    i dont think u will be able to digest it....

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Read the Oracle Datawarehousing Guide at http://tahiti.oracle.com -- they explain the features of Oracle that contribute towards ETL processing, and it will be an excellent place to start
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Jan 2002
    Location
    India
    Posts
    105
    There are many tools as per differnt requirments
    But my Heart goes with PL/SQL you can just do any thing with it in ETL(Even loading if you use utl_file package).

    Currently I am working on same thing..


    Virajvk
    -----------------
    OCP 9i DBA

    A Wise Man Knows How much he doesn't know !!!

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    i use informatica powermart. i hate it.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  7. #7
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by slimdave
    i use informatica powermart. i hate it.
    Slimdave :

    Wass wrong with INFORMATICA?

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    it's slow, full of idiotic "quirks", it doesn't maintain reliable dependencies, it is very very expensive, there are a great many useful Oracle features that just can't be supported using it (merge, insert /*+ append */ , bulk updates, insert into .. returning etc.), it's a bastard to debug a complex mapping blah blah blah. The metadata reporting functionality is abysmal -- it's there as a marketing tool only, according to informatica tech staff.

    I've been using it for over four years now, and i dislike it more and more.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  9. #9
    Join Date
    Mar 2002
    Posts
    200
    Originally posted by slimdave
    ...it's a bastard to debug a complex mapping ...
    Wow. That's classy language
    Last edited by quester; 02-12-2003 at 01:39 AM.

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Originally posted by slimdave
    i use informatica powermart. i hate it.
    agree, piece of crap

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width