Home | Services | Education
Informatica PowerMart / PowerCenter 6
Advanced Developer with New Features
Description
This course complements and extends the PowerMart / PowerCenter 6 – Basics course. The course is intended for developers with more than six months of PowerCenter 6 experience.
Duration: 5 days
Format: Instructor-led
Location: Info-Alchemy Training Center and on-site
Audience: PowerMart / PowerCenter developers
Pre-requisites: A minimum of six months experience with PowerMart / PowerCenter Agenda
Day One
Architectural Overview
* Highlights of all PowerCenter 6 new features
* Architecture differences between PowerCenter 5 and PowerCenter 6
Designer New Features
* Sourcing and Target Enhancements
* Mapping and Transformation Enhancements
Workflow Manager
* Workflow composition and Session Tasks
* Workflow Configuration Objects
Workflow Monitor GUI
* Workflow Monitoring
* Gantt Chart and Task View
New Metadata Features
* Metadata Extensions
Lab NF1 – Create a Session and Workflow
Lab NF2 – Run and Monitor the Workflow
Pipeline Partitioning
* New Partitioning Types
New PMCMD Command
* Repository Server and Agent
* Repository maintenance
Server Features
* Server Communication
* Expanded Server Variables
Upgrade Considerations
* PowerCenter 5 to PowerCenter 6 Object Treatment
* Repository Upgrade
Lab NF3 – Features and Techniques
Day Two
Introduction
* Introduction and Overview of Advanced class
Module: Advanced Mapping Techniques
Advanced Mapping Techniques Overview
* Velocity Mapping Specifications document
* Mapping Techniques Topics
XML Sources and Targets
* Introduction to XML
* Importing XML Source and Target Definitions
Lab MT1 – Sourcing and Targeting XML files
Stored Procedures
* Introduction to Stored Procedures
* Importing a Stored Procedure into a Mapping
* Stored Procedure Properties
Lab MT2 – Stored Procedure Tax Code
Debugger
* Introduction to Debugger
* Advanced Debugger Options
Advanced Aggregator and Lookup Techniques
* Introduction to Aggregator and Lookups
* Denormalizing data using an Aggregator Transformation
* Using Multiple unconnected Lookups
* Advanced Lookup SQL overrides
Lab MT3 – Denormalize Data and Use Multiple Unconnected Lookups
Lab MT4 – Advanced Lookup Overrides
Mapping Variables and Parameters
* Introduction to Mapping Variables and Parameters
* Creating Mapping Variables and updating Variables
* Creating Parameter File and associating file to a Session
Lab MT5 – Dynamically Updating a Source Qualifier with Mapping Variable
Lab MT6 – Override Mapping Variable with Parameter File
Day Three
Module: Advanced Workflow Techniques
Advanced Workflow Techniques Overview
* Workflow Manager
* Workflow Technique Topics
Reusable Special Objects
* Scheduler
* Session Configuration
Lab WT1 – Use a Wizard to Create Multiple Sequential Workflows
Lab WT2 – Reusable Schedule for a Workflow
Lab WT3 – Reusable Configuration for a Workflow
Reusable Tasks
* Task Designer properties
* E-mail, Command and Session Task Properties
Non-reusable Tasks
* Overview of non-reusable tasks
* Non-reusable Task properties
Lab WT4 – Session Configuration Object, Command Task & File List
Worklets
* Worklet Designer
* Reusable and Non-reusable Worklets
* Worklet limitations
Lab WT5 – Create Worklets Using Tasks
Lab WT6 – Event Wait with Pre Defined Event
Lab WT7 – User Defined Event, Event Raise and Event Wait
Lab WT8 – Assignment Task & Workflow Variable
Day Four
Module: Error Handling
Introduction to Error Handling Using Mapping Techniques
* Overview of Error Handling Topics
* Velocity Error Handling Strategies
Transaction Control Transformation
* Overview of Transaction Control and properties
* Uses and Limitations of Transaction Control
Lab ER1 – Transaction Control Error Handling
Error Handling Using Mapping Techniques
* Row by Row Error Handling strategies for Fatal and Non-Fatal Errors
Lab ER2 – Error Handling Fatal and Non-Fatal
Lab ER3 – Error Handling with Normalizer
Module: Performance Tuning
Performance Tuning Methodology Overview
* Performance Tuning Topics
* Overview of the System Environment
Measuring Performance and Establishing Baselines
* Identifying Bottlenecks
* Monitoring External Processes
* Network and ETL baselines
* Server Architecture
Lab PT1 – Establishing Baselines and Partitioning by Flat Files
Worklets
* Enhanced Data Parallelism
* Repartitioning Points
Lab PT2 – Partitioning Points
Day Five
Identify Bottlenecks
* Identifying Source, Target, Mapping and Session Bottlenecks
Lab PT3 – Oracle Loader
Optimization Methodology to Tune Informatica Components
* Mapping and Sessions optimization
* Calculating Cache Sizes
* Named Versus Unnamed Lookup Caches
Lab PT4 – Persistent Named Lookup Cache
PMCMD Features
* Overview of PMCMD and functions
Lab PT5 –PMCMD in Interactive and Command Line Mode
Module: Security and Basic Administration
Overview of Basic Administration
* Basic Security Tasks
* Basic Folder Administration
Lab SA1 – Security and Administration
Module: Migration
Overview of Migration Strategies
* Migration Strategies for One Repository
* Migration Strategies for Multiple Repository
Lab MI1 – Migrate within One Repository
Lab MI2 – Migrate Across Repositories
Lab MI2 – Backup and Restore Repositories
Module: Velocity Methodology Presentation
Overview of Velocity
* Velocity Phases
* Velocity Best Practices
* Velocity Deliverables
Lab VM1 – Mapping Specification Deliverable
Lab VM2 – Naming Conventions Best Practices
-------------------------------------------------------------------------
To register for a class, contact Info-Alchemy Education Services through our email at education@info-alchemy.com for additional information.
|
