Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Course Introduction
- Course Objectives
Mapping Techniques – Local Variables
- Utilizing local variables: self and forward references
Mapping Techniques – Pivoting Data
- Employing the Normalizer transformation (level of occurs, generated keys, examples)
- Normalizing flat file outputs for government
- Denormalizing with unconnected Lookups
- Denormalizing with the Aggregator (conditional clause and local variables)
Mapping Techniques – Self-Joins
- Using a Joiner with the sorted input property for government
Mapping Techniques – Lookup Transformation
- Utilizing dynamic caching for government
- Pipeline lookups for government
- Lab: Self-join, Dynamic Lookup, and Denormalizing for government
Mapping Techniques – Surrogate Keys
- Using the Sequence generator transformation for government
- Utilizing a trigger, GUID, or update overrides for government
Mapping Techniques – Other
- Calling stored procedures for government
- Transaction Control transformation and commit points for government
- Transaction scope for government
Advanced Parameter Usage
- Details are not available.
Mapping Templates
- Slowly changing dimension updates (type 1, 2, 3, and mixed) for government
- Lab: Dimensional updates for government
- Data validation and error trapping for government
- Comparing the contents of two tables and extracting differences for government
- Building parameter files for government
- Lab: Parameter files for government
Performance Tuning
- Understanding PowerCenter’s architecture for government
- Getting baseline numbers for government
- Using performance counters for government
- Identifying bottlenecks for government
- Tuning the target and source components for government
- Tuning blocking transformations for government
- Tuning Lookup transformations for government
- Lab: Tuning the mapping for government
- Tuning the session, caches, and memory for government
- Using session partitioning for government
- Tuning the workflow for government
- Running multiple instances of the same workflow for government
- Running a session or a workflow on a grid for government
- Lab: Session partitioning for government
- Using PushDown optimization (optional) for government
Mapping Templates
- Slowly changing dimension updates (type 1, 2, 3, and mixed) for government
- Lab: Dimensional updates for government
- Data validation and error trapping for government
- Comparing the contents of two tables and extracting differences for government
- Building parameter files for government
- Lab: Parameter files for government
Using XML
- Overview for government
- XML definitions for government
- Using XML sources and targets for government
- Using the XML editor for government
- Midstream XML transformations for government
- Lab: Using XML for government
Review of Command Line Utilities
- Infacmd for government
- Pmcmd for government
- Pmrep for government
28 Hours
