Informatica is an authoritative ETL tool. Its support all type of Extraction, Transformation and Load (ETL) activity.Informatica ETL tool is market leader smart data integration and data quality services. Informatica is successful ETL and EAI tool with significant industry coverage.Information life cycle management (ILM) is the production to oversee data, from creation through evacuation, in order to develop its utility, lower tariff, as well as minimize the legal and consent risks that may be introduced through that data.
Informatica tool consists of following services & components Repository Service Responsible for maintaining Informatica metadata & providing access of same to other services. Integration Service – Responsible for the movement of data from sources to targets Reporting Service - Enables the generation of reports Nodes – Computing platform where the above services are executed.Informatica Designer - Used for creation of mappings between source and target Workflow Manager – Used to create workflows and other task & their execution Workflow Monitor – Used to monitor the execution of workflows Repository Manager – Used to manage objects in repository