Course Contents

Informatica 9.5 Online Training Course Topics 

Duration: 4 –  5 Weeks

Data warehouse basics

• OLTP System
• Data warehouse
• Different Definitions of data warehouse
• Difference between OPERATIONAL DS AND DWH
• Types of ETL
• Data Extraction
• Types of Data loading
• Data Aggregation
• Data warehouse Approaches
• Top down approach and Bottom up approach
• DW Life cycle
• DW-database design
• Star schema and Snow flake schema
• Facts and dimensions
• Types of Dimensions
• Types of fact table
• Types of Olap

Informatica Power Center 9.1

Power center Installation&Administration

• Informatica Power center architecture
• Power center components
• ETL Plan
• Power center Clients
• Designer
• Workflow manager
• Work Flow monitor
• Workflow manager
• Repository manager
• Power center repository
• Administrative tool
• Repository services
• Integration services
• Power center domain
• Application services
• Concept of nodes and grid
• Service manager
• Power center administration console 

Repository Administration

• Creating Repository Users and Groups.
• Connecting to the Repository.
• Creating a Group
• Assigning Privileges to a Group.
• Creating a User
• Creating a Folder
• Folder Permissions
• Creating Folders

 Using the designer

• Creating Source Tables.
• Creating Target Definitions.
• Creating Target Tables
• Creating a Pass-Through Mapping
• Creating source definitions
• Creating a Mapping
• Connecting Transformations

Transformation Creation

• Using Transformations
• Active and passive transformations
• Aggregator Transformations
• Sorter Transformations
• Filter Transformation
• Joiner Transformation
• Lookup Transformation
• Normalizer Transformation
• Rank Transformation
• Router Transformation
• Sequence Generator Transformation
• Expression Transformation
• Sorter Transformation
• Source Qualifier Transformation
• Stored Procedure Transformation
• Union Transformation
• Router Transformation
• Extraction of data from flat files
• Connecting the Target
• Designer Tips.
• Using the Overview Window
• Arranging Transformations
• Creating the Session
• Creating the Workflow
• Creating a Mapping with Fact and Dimension Tables
• Creating a Filter Transformation
• Creating a Sequence Generator Transformation
• Creating a Stored Procedure Transformation
• Completing the Mapping
• Creating a Workflow
• Creating a Link Condition.
• Running the Workflow

Using the workflow manager

• Connecting Transformations
• Creating Sessions and Workflows
• Configuring Database Connections in the Workflow Manager
• Creating a Reusable Session
• Creating a Workflow
• Running and Monitoring Workflows
• Opening the Workflow Monitor
• Running the Workflow

 Workflow Tasks

•  Session
•  Assignment task
• Link task
• Event raise task
• Event wait task
• Timer task
• Post session and Pre-session commands
• Session recovery
• Commit points
• Creation of Parameter file
• Mapping and session parameter

 Performance tuning in ETL

• Various optimization techniques
• Pushdown optimization
• Incremental aggregation

 Administration related tasks

•  Taking backups
•  Creating users
•  Security
•  Code migration