Home | Services | Education
Informatica PowerMart / PowerCenter 6
Basics
Description
This four-day course emphasizes more hands-on exposure than any previous data integration platform products course offering. Students will be exposed to all core features through lecture with the majority of the learning experience acquired while working through more than twenty-five hands-on exercises. Included are Instructor-led exercises strategically designed to give more exposure to tips and tricks.
Duration: 4 days
Format: Instructor-led
Location: Info Alchemy Training Center and on-site
Audience: PowerMart / PowerCenter developers
Pre-requisites: Windows GUI, RDBMS concepts; Basic knowledge of data warehousing concepts is recommended Agenda
Day One
Introduction and Architectural Overview
* Course objectives and materials
* Informatica resources
* Informatica Professional Certification
* Extraction, Transformation and Loading process
* PowerCenter 6 architecture
* Additional Solutions
* The Design Process
Demonstration
Repository Topics
* Repository Server and Agent
* Repository maintenance
* Repository Server Administration Console
* Security, repository privileges and folder permissions
* Object sharing, searching, and locking
* Metadata extensions
Lab 1 – Create a Folder
Source Object Definitions
* Source types
* Source properties
Lab 2 – Analyze Source Data
Target Object Definitions
* Target types
* Target properties
Lab 3 – Import Target Schema
Transformation Concepts
* Transformation types and views
* Transformation features and ports
* Expression transformation
* Informatica functions and data types
Mappings
* Mapping components
* Source Qualifier transformation
* Pre SQL and Post SQL
* Mapping validation
* Data flow rules
* Object export and import
Lab 4 - Create a Mapping
Day Two
Workflows
* Workflow Tools
* Workflow structure and configuration
* Workflow Connections
* Workflow Tasks
* Workflow Design and properties
Session Tasks
* Session Task properties
* Session components
* Transformation overrides
* Session partitions
Lab 5 – Create a Workflow
Workflow Monitoring
* Workflow Monitor views
* Monitoring a Server
* Actions initiated from the Workflow Monitor
* Filtering views
* Truncating Monitor Logs
Lab 6 – Start and Monitor a Workflow
Lab 7 – Features and Techniques I
Debugger
* Debugger features
* Debugger windows & indicators
* Tips for using the Debugger
Lab 8 - The Debugger
Filter transformation
* Filter properties
Lab 9 - Flat File Wizard and Filter
Aggregator transformation
* Aggregation functions and expressions
* Aggregator properties
* Using sorted data
* Incremental Aggregation
Joiner transformation
* Joiner types
* Joiner conditions and properties
* Joiner usage and Nested joins
Lab 10 - Heterogeneous Join
Sorter transformation
* Sorter properties
* Sorter limitations
Lab 11 – Sorter
Day Three
Lookup transformation
* Lookup principles
* Lookup properties
* Lookup techniques
Lab 12: Basic Lookup
Target options
* Row type indicators
* Row loading operations
* Constraint-based loading
* Rejected row handling options
Lab 13: Deleting Rows
Update Strategy transformation
* Update Strategy expressions
* Smart aggregation
* Refresh strategies
Lab 14 - Data Driven Inserts and Rejects
Lab 15 - Incremental Update
Lab 16: Features and Techniques II
Router transformation
* Using a Router
* Router groups
Lab 17 – Router
Mapping Parameters and Variables
* Mapping parameter and variable usage
* System Variables
* Variable functions
Conditional lookups
* Usage and techniques
* Advantage
* Functionality
Lab 18 – Straight Load
Lab 19 - Conditional Lookup
Day Four
Heterogeneous Targets
* Heterogeneous target types
* Target type conversions and limitations
Lab 20 - Heterogeneous Targets
Mapplets
* Functionality and advantages
* Mapplet types and structure
* Mapplet limitations
Lab 21 - Mapplets
Reusable transformations
* Advantages
* Limitations
* Promoting and copying transformations
Lab 22 - Reusable transformations
Sequence Generator transformation
* Using a Sequence Generator
* Sequence Generator properties
Dynamic Lookup
* Dynamic lookup theory
* Usage and functionality
* Advantages
Lab 23 - Dynamic Lookup
Concurrent and sequential Workflows
* Concurrent Workflows
* Sequential Workflows
* Stopping, starting and suspending tasks and workflows
Lab 24 – Sequential Workflow (extra credit)
Additional Transformations
* Rank transformation
* Normalizer transformation
* Stored Procedure transformation
* External Procedure transformation
* Advanced External Procedure transformation
* Transaction Control transformation
-------------------------------------------------------------------------
To register for a class, contact Info-Alchemy Education Services through our email at education@info-alchemy.com for additional information.
|
