Informatica Power Center 8.6 Level-1 Developer

Introduction to Informatica Powercenter 8.6
Products of Informatica
Informatica Architecture

• Overview
• Connectivity
• Integration/Repository service process
• Load Balancer
• Grids /Nodes /Domain
• Code Pages and Data Movement modes
• Introduction to ETL
• Why Informatica
• Informatica Client Tools

Introduction to ETL

• Mapping Designer
  • Overview
  • Connecting mapping objects
  • linking ports
  • propagate attributes
  • working with targets /sources
  • Creating Mappings /mapplets (Reusable Objects)
  • Validating a mapping
• Workflow Manager
  • Copy repository objects
  • Check in & check out versioned objects
  • Links
  • Creating Workflow/Sessions/Tasks (Reusable Objects)
• Repository Manager
  • Understanding the Repository,Folders
  • Exporting and importing objects
• Workflow Monitor
  • Gant /task view Reporting.
  • Session and work flow logs

Transformations

• Source qualifier
  • Overview
  • Properties
  • default query
  • joining source data
  • adding SQL query
  • user defined join
  • outer join support
  • source filter
  • sorted ports
  • pre and post session SQL commands
• Update strategy
  • Overview
  • Flagging rows within a mapping
  • Setting update strategy for a session
  • Check list
• Expression
  • Overview
  • Components
  • Configuring ports
  • input vs. Output vs. Variable
• Aggregator
  • Overview
  • Components
  • Configuring aggregate caches
  • Aggregate expressions
  • Group by ports
  • Sorted input
  • Aggregator transformation
• Joiner
  • Overview
  • Transformation properties
  • Condition type
  • Sorted input
• Router
  • working with groups
  • working with ports
  • Rules for connection
• Rank
  • Overview
  • Ports available
  • Defining groups
• Sorter
  • Overview
  • Data sorting
  • Properties
  • Cache
  • work directory
• Filter
  • Overview
  • Components
  • Condition
  • Tips
• Sequence generator
  • Overview
  • Uses of sequence generator
  • Properties
  • Ports
  • Reusable sequence generator
• Union
  • Overview
  • Groups and ports
  • Usage
• Lookup (connected/unconnected)
  • Overview
  • Source types
  • Connected and Unconnected
  • Components properties
  • Look up query
  • SQL Over riding guidelines
  • Look up caches
  • Unconnected transformations
• Stored procedure (connected/unconnected)
  • Overview
  • Methods of creating sp in a mapping
  • Configuring connected transformation
  • Configuring un connected transformation
  • Error handling
  • Expression rules
• Transaction control
  • Overview
  • Tct properties
  • Tct in mappings
  • Built in variables
  • Mapping guidelines & validation
• Normalizer
  • Overview
  • Components
  • Generated keys
  • Pipeline Normalizer
  • Using Normalizer transformation
• Some Important Concepts
  • SQL Override   
  • Mapping/ Workflow Variables
  • Mapping/ Workflow Parameters   
  • Working with/ Configuring Parameter File.   
  • Overview to PMCMD/PMREP Commands.   
  • Enhanced features in Informatica Version 9.0.1
• Overview on Data warehousing Concepts
  • Introduction to Data Warehousing
  • Introduction to OLTP, ETL and OLAP Systems
  • Star Schema
  • Snowflake Schema
  • Types of Fact and Dimension Tables
  • Introduction to Slowly Changing Dimension Type 1/2/3