INFORMATICA POWERCENTER 8.5 & 9 ONLINE TRAINING

INFORMATICA POWERCENTER 8.5 & 9 ONLINE TRAINING

INFORMATICA POWERCENTER 8.5 & 9 ONLINE TRAINING 



FOR FREE DEMO contact us at:

EMail:    info@apex-online-it-training.com
Phone:    +91-868-622-2553

Course Duration:  30 Hours

ABOUT THE TRAINER

  • 8 YEARS OF INDUSTRY EXPERIENCE & WORKING FOR AN MNC IN INDIA
  • 5 YEARS OF EXPERIENCE IN ONLINE & CLASS ROOM TRANING

 

 

Informatica Power Center 8.5 online training Course content

 

 

Data warehousing concepts 

Introduction to DWH

Characteristics of DWH

OLTP/OLAP concepts and differences

Sample DWH applications

ETL/Reporting concepts

Star/Snowflake/Galaxy schema

Informatica 8.6

Informatica installation

Informatica Admin console (user creation/security/access)

Infomatica client tools (Designer,Worfklow Manager,Workflow monitor,Repository manager)

Importing source/target definitions

Creating mappings

Transformations (Active and Passive) & Reusable Transformations

Working with transformations on business requirements

Mappings/Mapplets (Reusable Mapplets)

Using Store procedure

Workflow Manager

Creating various tasks

Integrating mappings with sessions

Working with Integration Service - Creating Worklets

Sequential/Parallel flow of execution

Workflow Monitor

Executing the workflows

Executing sessions separately

Hands on monitoring the applications (Required for Production support)

Working on various issues