ETL Courses

Informatica Course Content

Informatica Training Course

A. Informatica PowerCenter Designer

B. Informatica PowerCenter Workflow Manager

C. Informatica Power Center Workflow Monitor

D. Informatica PowerCenter Workflow Repository Manager

E. Informatica Admin Console

A. Informatica PowerCenter Designer
· Understanding Source and Target

- Create new connection(ODBC, Oracle etc)

- Create and import Source and Target

- Understanding the use of Shortcut

Understanding the Transformation

- Understanding Passive and Active Transformation

- Create and use of below transformation

• Expression

• Lookup(Connected and Unconnected)

•Aggregrator,Sorter,SQ,Union,Joiner,Filter,Router,update startegy etc

Understanding of use of Mapping
- Design new mapping
- Use transformation in the mapping
-Debugg the mapping
· Understanding of use of Mapplet
- Design new mapplet
- Use mapplet in the mapping
-Advantage of the mapplet
B. Informatica PowerCenter Workflow Manager

- Understanding of workflow
- create and execute new workflow
- Create new Task to execute the mapping
- Understanding use of  connection at Source and Target
- Understanding of task Session,event wait,email,Assigmnet etc
- understanding how to Schedule the workflow
C. Informatica PowerCenter Workflow Monitor

- Monitor the job 
- understanding of run statistics of each job
-understanding of Stop/Abort of running job

D. Informatica PowerCenter Workflow Repository Manager

- Understanding use of Repository Manager
- understanding migrate the job from environment to another environment
- Check in check out a workflow
- Understanding of creating new DG
E. Informatica Admin Console

-Understanding how to create a new user

-Understating how to create a new folder

-Understating how to provide a Role to a User.