Home | Services | Education
Informatica PowerMart / PowerCenter 6
New Features
Description
This course focuses on the new features in release 6 of our data integration platform products, which encompass PowerMart 6, PowerCenter 6 and PowerCenter RT. The course is designed for existing PowerMart and PowerCenter developers with more than six months experience who need to come up to speed quickly.
Duration: 2 Days
Format: Instructor-led
Location: Info Alchemy Training Center or on-site
Audience: PowerMart / PowerCenter Developers
Pre-requisites: A Minimum of six months experience with PowerMart / PowerCenter 5 Agenda
Day One
Introduction and New Features Overview
* Highlights of all PowerCenter 6 new features
Architectural Overview
* PowerCenter 5 architecture
* PowerCenter 6 architecture
Workflow and Task Introduction and Overview
* Introduction to the Task concept
* Re-usable Tasks
* Non-reusable Tasks
* Introduction to Workflows
Introduction to the new Workflow Manager GUI
* Task Developer
* Worklet Designer
* Workflow Designer
* Task Toolbar
* Sample Workflow Architectures
Introduction to the new Workflow Monitor GUI
* Workflow Monitoring
* Gantt Chart View
* Task View
* Actions initiated from the Workflow Monitor
Introduction to Setting Database Connections in PowerCenter 6
* Relational database Native Connections
Demonstration
Introduction to Session Tasks
* Session Task components (Exploring the new GUI)
* Setting Session Task properties
* Selecting database connections
* Transformation overrides
Introduction to New Metadata Features
* Metadata Extensions
* Metadata Reporter
Workflow Composition
* Designing a Workflow
* Workflow Links
* Developing Workflows
* Optional Workflow Properties
* Concurrent Workflows
* Sequential Workflows
* Scheduling Workflows
* Starting Tasks and Workflows
Lab 1 – Create a Session and Workflow
Lab 2 – Run and Monitor the Workflow
Introduction to Designer New Features
* Heterogeneous Targets
* Mapping Link Tracing
* Improved port Linking
* Launch Custom Tools from inside Designer
* Sorter properties
* Sorter Transformation
Lab 3 – Sorter Transformation
* Copy and Paste to a Mapping
* Dependency analysis
* Improved object comparison
* Additional Numeric / Datetime support for flatfiles
* Port re-naming
* Expression Editor sizing
* Mapplet Enhancements
* New Transformation Language functions
* Pre- and Post-SQL
* Dynamic Cache support for Updates
* Insert Else Update
* Update Else Insert
Lab 4 - Dynamic Lookup / Update-to-Cache
Day Two
Other Reusable Tasks
Command Task
Email Task
Advanced Workflow Configuration
* Workflow Configuration Objects
* Schedulers
Lab 5 - Session Configuration Object and Command Task
Non-Reusable Tasks
* Decision Task
* Assignment Task
* Timer Tasks
* Control Task
* Event Wait Task
* Event Raise Task
Lab 6 - Timer and Decision Task
Worklet Designer
* Reusable Worklets
* Non-reusable Worklets
Lab 7 – Worklet
Pipeline Partitioning
* New Partitioning Types
* Key Range Partitioning
* Round Robin Partitioning
* Hash Partitioning
* Pass-through Partitioning
* Re-Partition Points
Lab 8 - Partitioning
New PMCMC Commands
* Repository Server and Agent
* Repository maintenance
* Security and privileges
* Object sharing, searching, and locking
* Metadata extensions
Introduction to new PowerCenter 6 Server Features
* Server Communication
* Expanded Server Variables
* Oracle Bulk / Teradata / DB2 External Loader Support
* PowerCenterRT (Real Time Support)
* Tibco Rendevous Interface
Introduction to the Repository Server
* Repository Server and Agent Architecture
* Repository and Repository Server Connectivity
* Multiple Repository Connectivity
* Improved Lock Management
* Use of the TCP/IP protocol with Repository Server
* Repository Server Configuration
* Repository Maintenance
Repository Agent
* Agent Connectivity to the Server, Repository Server and Repository
* Agent Architecture
Repository Management
* Connect to the Repository Server
* Creating Repository Configurations
* Create a Repository
* Start the Repository Agent
* Repository Maintenance Tasks
* Sending Repository Notifications
Expanded PMREP Commands
* Connect to the Repository Server
* Creating Repository Configurations
* Create a Repository
* Start the Repository Agent
* Repository Maintenance Tasks
* Sending Repository Notifications
Lab 9 – Event Wait /Event Raise & User-Defined Event
Upgrade Considerations
* PowerCenter 5 to PowerCenter 6 Object Treatment
* Session and Batch Treatment
* Nested Batch Treatment
* Event-based Scheduling Treatment
* Post-Session Email Treatment
* Repository Upgrade
Lab 10 – Email Task (Optional)
-------------------------------------------------------------------------
To register for a class, contact Info-Alchemy Education Services through our email at education@info-alchemy.com for additional information.
|
