 |
Informatica PowerCenter 8.x Level I Developer
This four-day, instructor-led course provides the basic skills and knowledge developers new to Informatica PowerCenter require to implement data integration projects,
exposing core features of PowerCenter releases 8.0 to 8.6 through lecture and hands-on exercises..
In addition to gaining tremendous insight into the data integration platform, students will be exposed to Informatica Velocity Best Practices,
troubleshooting techniques, and the use of technical support options. The course concludes with workshops in which students design and implement a
data integration project based on business requirements.
Topics covered include:
- Data Integration Concepts;
- PowerCenter Components and User Interface;
- Source Qualifier;
- File Lists,
- Workflow Scheduler;
- Reusable Transformations;
- Debugger;
- Detailed Review of the Expression,
- Filter, Sorter, Aggregator, Joiner, Lookup,
- Update Strategy, Router, and Sequence Generator Transformations;
- Source and Target Overrides;
- Parameters and Variables;
- Self-Join;
- Incremental Aggregation;
- Dynamic Lookup Cache;
- Mapplets;
- Workflow Configuration and Techniques;
- Reusable Schedule for a Workflow;
- Session Configuration;
- Tasks and Worklets.
Duration:
4 Days
|
|
Informatica PowerCenter 8.x Level I Administrator
This four day, instructor-led course introduces the student to PowerCenter 8.5 + Administrator, and is aimed at educating the student on the administration
of the PowerCenter domain. This course is designed for administratorsand consultants, with experience in networking technology, server machines and
database concepts and technology.
When you have completed this course, you should be able to:
- Describe, create and install PowerCenter
- Configure and Administer the PowerCenter Domain
- Create and understand PowerCenter Services
- Create and implement integrated Security
- Create and execute Deployment Strategies
- Use Command-Line Scripting to perform many administrative functions
- Use Metadata Reporting to verify all objects in repository
Topics covered include:
- Essentials of the PowerCenter 8.5+ Architecture
- Configure a PowerCenter 8.5+ environment using recognized Best Practices
- Prepare for and Install PowerCenter 8.5+
- Configure PowerCenter 8.5+ application services
- Understand and configure PC Unified Security
- Describe the architecture of the PowerCenter Services
- Methods of Powercenter Deployments
- Use PowerCenter command line programs to administer the domain
- Implement a Subject Area into the PowerCenter architecture
- Use Metadata Exchange (MX) views to report PowerCenter operational information
- Create and configure a PowerCenter Reporting Service
- Understand the purpose of the Data Analyzer tool
- Learn how to configure and use RTM Service
- Learn how to manage the PowerCenter Domain
Duration:
4 Day
|
|
Informatica PowerCenter 8.x Level II Developer
This four-day, instructor-led course complements and extends "PowerCenter 8 Level I Developer" with advanced topics and extended labs.
The course is intended for developers with more than Three months of PowerCenter 8 experience and is also designed for existing
PowerCenter 7 developers with more than six months experience who need to come up to speed quickly in PowerCenter 8.
Topics covered include:
- Advanced Mapping Techniques;
- Advanced Workflow Techniques;
- Transaction Control;
- Error Handling;
- Performance Tuning;
- Stored Procedures and Custom Transformations;
- Repository Reporting;
- Memory Allocation;
- Pipeline Partitioning.
Duration:
4 Days
|
|
Informatica Data Quality 8.x
This four-day, instructor led course introduces the student to the Informatica Data Quality Workbench option through lecture and hands-on exercises.
The course is designed for all users who are new to Informatica Data Quality. The course covers the basic tasks of using Informatica Data Quality.
Topics covered include:
- Analysis plans including Data Quality scorecards,
- Matching plans and Standardization routines to cleanse data and validate addresses.
Duration:
4 Days
|
|
Informatica Data Explorer 8.x
This three day, instructor-led course introduces students to the Informatica Data Explorer product through lecture and hands-on exercises.
The course is designed for users who are new to Informatica Data Explorer.
Topics covered include:
- Define complex data structures,
- Perform three-dimensional structural analysis of data,
- Discover data quality inconsistencies,
- Use Data Explorer tags,
- Create a data cleansing process, and more.
Duration:
3 Days
|