Informatica Beginner Tutorial

Informatica is ETL tool used to load data into data warehouse.It is one of the widely used tools in the market apart from abinitio and IBM datastage.
Informatica has got capability to connect to various databases.
There are four tools in informatica

1. Mapping Desinger : This is used to create Mapping(I will explain latter what exactly you mean by mappings.)

2. Workflow Manager: Once you have created the Mapping you will need to run it through session
and workflow.These tasks are performed in manager

3. Workflow Monitor:When you run the workflow or session.You will see the status i.e whether it is successful or not in workflow Monitor

4. Repository Manager : This is used for various admin tasks like expoting importing mapping worklfow etc