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
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
|
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 |