1. How informatica useful now a days

2. Connection informatica with database 

3.Informatica client tools (Power center designer, Power center Workflow manager, Power center workflow monitor, Power center Repository Manager,)

4. OLTP table , OLAP table

5. Informatica objects : Sources,Targets, Mappings, Transformations, Mapplets, Sessions, Tasks, Workflows, Worklets.

Repository Manager :
Configuring the domains
Creation of folders in the Repository

Tools in informatica Power Center Designer:

1.source analyzer
2.Target designer
3.Transformation developer
4.mapplet designer
5.mapping designer
Creating sources, targets, transformations,mapplets and mappings.

Creating ODBC Connections for importing the source and target from dabase.

Types of Tranformations:

• Filter Transformation
• router transformastion
• Expression transformation
• Aggregator transformation
• sorter transformation
• joiner transformation
• union transformation
• source qualifier transformation
• Connected / Un connected transformation
•  Dynamic Lookup transformation
• Rank transformation
• Update Strategy transformation
• Sequence Generator transformation
• Transaction Control transformation
• Normalizer transformation
• Reusable Transformations
• Mapplets transformation

Workflow Manager :

Creating sessions and workflows
Creatings relational connections source and target on database

Workflow Monitor:

Monitoring the workflows and checking the session logs.