The term ETL which stands for extract, transform, and load is a three-stage process in database usage and data warehousing. It enables integration and analysis of the data stored in different databases and heterogeneous formats. After it is collected from multiple sources (extraction), the data is reformatted and cleansed for operational needs (transformation). Finally, it is loaded into a target database, data warehouse or a data mart to be analyzed. In most of the Data Integration or Data Warehousing projects, the amount of time spent in enforcing business data domain rules and/or business data integrity rules could be as high as 80 percent of the total time. And enforcement of such rules normally happens through Data Transformations.
Informatica has several products focused on data integration. It has become so popular that Informatica PowerCenter has now become synonymous to Informatica. It offers products for ETL, data masking, data Quality, data replica, data virtualization, master data management, etc. Informatica Power center ETL/Data Integration tool is a most widely used tool and in the common term when we say Informatica, it refers to the Informatica Power Center tool for ETL. Informatica Power center is used for Data integration.