Saturday 11 June 2011

Informatica is a powerful Extraction, Transformation, and Loading tool and is been deployed for data warehouse development in the Business Intelligence Team. Informatica comes with the following clients to perform various tasks.
·        Designer – used to develop transformations/mappings
·        Workflow Manager / Workflow Monitor replace the Server Manager - used to create sessions / workflows/ worklets to run, schedule, and monitor mappings for data movement
·        Repository Manager – used to maintain folders, users, permissions, locks, and repositories.
·        Integration Services – the “workhorse” of the domain. Informatica Server is the component responsible for the actual work of moving data according to the mappings developed and placed into operation. It contains several distinct parts such as the Load Manager, Data Transformation Manager, Reader and Writer.
·        Repository Services-  Informatica client tools and  Informatica Server connect to the repository database over the network through the Repository Server.

No comments:

Post a Comment