What is ETL (Extract, transform, Load) and write some ETL tools.
Essentially, ETL means to extract, transform, and load. The ETL process involves extracting, transforming, and loading data from different databases into the target database or file. It forms the basis of a data warehouse. Here are a few ETL tools :
* IBM Datastage
* Informatica PowerCenter
* Abinitio
* Talend Studio, etc.
It performs the following functions :
* Obtains data from sources
* Analyze, transform, and cleans up data
* Indexes and summarizes data
* Obtains and loads data into the warehouse
* Monitors changes to source data needed for the warehouse
* Restructures keys
* Keeps track of metadata
* Updates data in the warehouse
