Home | Services | Education
Informatica PowerMart / PowerCenter 7
Basics
Description
This four-day course emphasizes more hands-on exposure than any previous data integration platform products course offering. Students will be exposed to all core features through lecture with the majority of the learning experience acquired while working through more than twenty-five hands-on exercises. Included are Instructor-led exercises strategically designed to give more exposure to tips and tricks. Duration: 4 days
Format: Instructor-led
Location: Info Alchemy Training Center and on-site
Audience: PowerCenter developers
Pre-requisites: Windows GUI, RDBMS concepts; Basic knowledge of data warehousing concepts is recommended
Agenda
Introduction and Architectural Overview
- Course objectives and materials
- Informatica resources
- About Informatica
- Informatica Professional Certification
- Extract, transform and load process
- PowerCenter 7 architecture
- Connectivity products for PowerCenter
- PowerCenter 7.1 options
- The Design and execution process
Demonstration
Source Object Definitions
- Methods of analyzing various source types
- Data Previewer
- Metadata extensions
Target Object Definitions
Mappings
- Transformation objects and views
- Source Qualifier transformation
- Pre-SQL and Post-SQL rules
- Expression transformation
- Informatica functions
- Variable ports
- Data types
- Mapping validation
Lab 2 - Create a Mapping
Workflows
- Workflow tools
- Workflow structure
- Workflow connections
- Workflow tasks
- Workflow design
- Workflow properties
- Workflow links
Session Tasks
- Creating session tasks
- Configuring session tasks
- Source and target properties
Monitoring Workflows
Debugger
- Debugger features
- Debugger windows & indicators
- Tips for using the Debugger
Lab 5 - The Debugger
Filter Transformation
Sorter Transformation
- Sorter functionality
- Sorter properties
Aggregator Transformation
- Aggregator transformation
- Aggregator expressions and functions
- Aggregator properties
- Using unsorted and sorted data
- Data flow rules
Joiner Transformation
Lookup Transformation
- Lookup principles
- Lookup properties
- Lookup caching
Lab 8: Basic Lookup
Target Options
- Target properties
- Update override
- Constraint-based loading
Lab 9: Deleting Rows
Update Strategy Transformation
Router Transformation
- Router functionality
- Router groups
Lab 13 – Router
Sequence Generator Transformation
- Sequence Generator functionality
- Sequence Generator properties
Parameters and Variables
- System Variables
- Mapping parameters and variables
- Parameter files
Unconnected Lookups
Heterogeneous Targets
Mapplets
- Mapplet Designer
- Mapplet advantages
- Mapplet types and rules
- Active and passive mapplets
- Mapplet parameters and variables
Lab 17 - Mapplets
Reusable Transformations
Session-Level Error Logging
- Setting on and off
- Data rejects with error logging off
- Error logging to database table and flat file
- Source row logging
Workflow Configuration
- Server connections
- Reusable workflow schedules
- Reusable session configurations
Reusable Tasks
Non-Reusable Tasks
- The decision task
- The assignment task
- The timer task
- The control task
- The event wait task
- The event raise task
Worklets
-------------------------------------------------------------------------
To register for a class, contact Info-Alchemy Education Services through our email at education@info-alchemy.com for additional information.
|
