• This course provides you the overview of Informatica PowerCenter Product and the concepts of data integration and data warehousing.
• You will learn how different development units of PowerCenter can be used to create a simple mapping.
• You will understand the features provided by Informatica to debug, troubleshoot and handle errors.
• You will learn the best practices for optimum performance of your ETL process & to manage the repository effectively. An overview of the PowerCenter administration console is given, and be able to explain integration and repository service properties.
• The Informatica Training Course will also deal with command line aspect of Informatica PowerCenter.

Course Details :

Informatica Training Outline 

1. Data Warehouse Introduction
2. Power Center Components

• Designer
• Repository Manager
• Workflow Manager
• Workflow Monitor

3. Power Center Admin Console Informatica Concepts and Overview

• Informatica Architecture
• Informatica Introduction
• Source Analyzer
• Target Designer
• Transformation Developer
• Mapping Designer
• Mapplet Designer
• Task developer
• Worklet Designer
• Workflow Designer

4. Sources

• Working with relational Sources
• Working with Flat Files
• Targets
• Working with Relational Targets
• Working with Flat file Targets 

5. Transformations - Active and Passive Transformations 

• Expression
• Lookup --Different types of lookup Caches
• Sequence Generator
• Filter
• Joiner
• Sorter
• Rank
• Router
• Aggregator
• Source Qualifier
• Update Strategy
• Normalizer
• Union Transformation
• Slowly Changing Dimension§ SCD Type1 § SCD Type2 -- Date, Flag and Version § SCD Type3
• Workflow Manger § Creating Reusable tasks § Workflows, Worklets & Sessions § Tasks § Session § Assignment task § Control Task § Event raise task § Event wait task § Timer task · Monitoring workflows and debugging errors

6. Interview Question and Preparation