ETL stands for extraction, transformation and loading. ETL is a process that involves the following tasks:
- extracting data from source operational or archive systems which are the primary source of data for the data warehouse
- transforming the data - which may involve cleaning, filtering, validating and applying business rules
- loading the data into a data warehouse or any other database or application that houses data
Informatica is a tool, supporting all the steps of Extraction, Transformation and Load process. Now a day Informatica is also being used as an Integration tool.
Informatica is an easy to use tool. It has got a simple visual interface like forms in visual basic. You just need to drag and drop different objects (known as transformations) and design process flow for Data extraction transformation and load. These process flow diagrams are known as mappings.
Once a mapping is made, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases.
Once a mapping is made, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases.
It can effectively join data from two distinct data sources (even a xml file can be joined with a relational table). In all, Informatica has got the ability to effectively integrate heterogeneous data sources & converting raw data into useful information.
In short, Informatica is world leading ETL tool & it’s rapidly acquiring market as an Enterprise Integration Platform.
Informatica PowerCenter is not just a tool but an end-to-end data processing and data integration environment. It facilitates organizations to collect, centrally process and redistribute data. It can be used just to integrate two different systems like SAP and MQ Series or to load data warehouses or Operational Data Stores (ODS).
Informatica PowerCenter also includes many add-on tools to report the data being processed, business rules applied and quality of data before and after processing.
Informatica Architecture
please visit following site for more information it is very helpful.
Comments
Post a Comment