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