Home | Services | Education
Informatica PowerMart / PowerCenter 6
Basics Plus
Description
This course exposes the core features of Informatica PowerMart / PowerCenter through lecture and more than twenty-five hands-on exercises. In addition to gaining tremendous insight into the data integration platform, students will be expose to Informatica Velocity Best Practices plus one-day introduction to workflows and worklets.
Duration: 5 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
Day Five
Workflow Techniques Overview
* Workflow Topics
Reusable Special Objects
* Scheduler properties
* Session Configuration properties
Lab WT1 - Use A Wizard to Create Multiple Sequential Workflows
Lab WT2 – Reusable Schedule for a Workflow
Lab WT3 – Reusable Configuration for a Workflow
Reusable Tasks
* Task Designer properties
* E-mail Task
* Command Task
* Session Task
Non-Reusable Tasks
* Overview of non-reusable Tasks
* Non-reusable Task properties
Lab WT4 -Session Configuration Object, Command Task & File List
Worklets
* Worklet Designer
* Reusable and Non-Reusable Worklets
* Worklet Limitations
Lab WT5 - Create Worklets using Tasks
Lab WT6 – Event Wait with Pre Defined Event (Extra Credit)
Lab WT7 – User Defined Event, Event Raise and Event Wait (Extra Credit)
-------------------------------------------------------------------------
To register for a class, contact Info-Alchemy Education Services through our email at education@info-alchemy.com for additional information.
|
