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.