ETL Tools

[cyrus]

What is ETL Tools? What are the kinds of ETL Tools that are used in the market?

[zsk_00]

ETL --> Extraction Transformation and Loading
Its used to load/move data from anywhere to anywhere

Two types of ETL tools (that I know of)
1. ETL engines (no code is generated), you create a map (from source to target) and the ETL engine will load the data from source to target) example is Informatica.
2. ETL Code generators (you create the map, and the program will generate PL-SQL or java code) which you have to run to do the load data. Example is Oracle warehouse builder.

Zafar