Home | Services | Education
Informatica PowerMart / PowerCenter 7
New Features
Description
This course focuses on the new features in release 7 of our data integration platform products, which encompass PowerCenter 6. The course is designed for existing 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: PowerCenter Developers
Pre-requisites: A Minimum of six months experience with PowerCenter 6 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.
|
