-
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
-
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.
-
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"
-
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
-
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 !!!
-
i use informatica powermart. i hate it.
-
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"
-
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.
-
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 02:39 AM.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|