web statistics

Informatica Online Training

INFORMATICA 9.1 ONLINE TRAINING COURSE

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

 

Project Explanation