ETL is a type of data integration and involves an architecture that extracts, transforms, and then loads data in the target database or file. It is the foundation of
data warehouse.
An ETL system does the following:
- Extracts data from source systems
- Transforms and cleans up the data
- Indexes data
- Summarises data
- Loads data into the warehouse
- Tracks changes made to the source data required for the warehouse
- Restructures keys
- Maintains the metadata
- Refreshes the warehouse with updated data
Informatica is a data integration tool based on ETL architecture. It provides data integration software and services for various businesses, industries and government organisations
including telecommunication, health care, financial and insurance services.
- Informatica PowerCenter is a premium data integration solution available today.
- The reason it provides the best solution in large enterprises is because it is database neutral and hence can communicate with any database the most powerful data transformations tool. It converts one application’s data to another’s format.
