Informatica PowerCenter 9.
0 Developer
Benefits
Introduction
Informatica developer is a tool in Informatica 9.0 where you can de- ETL & Data Integration
velop data quality plans/mapping. This tool contains all the transfor- Data governance, Data migration, and Data warehousing.
mation of power center and other new transformations related to
data quality. These plans can be integrated with power center map- Pre-requisites
pings to schedule the job..In Informatica 9, Informatica data quality Databases basics knowledge
(IDQ) has been further integrated with the Informatica Platform and
performance, manageability and reusability have all been signifi- Duration
cantly enhanced.
35 hours/5 Full days/10-Half days
Course Content
Day 1
Day 2
Day 3
Day 4
Day 5
Refer Pg2 for Detailed Content
Session 1
Session 2
Introduction DW&BI
Introduction PowerCenter
Data warehouse & Business Intelligence Concepts
Transformation, Tasks
Data integration concepts
Components, Architecture
Theory
Theory/Demo
Session 3
Session 4
Source & Expression
Joiner & Lookup
Homogenous joins, Data type conversions
Pipeline Mapping, Target load plans
Data manipulation ,Filter data, Scheduling Mapping
Heterogeneous joins, Properties, Shortcuts
Theory/Demo/Practices
Theory/Demo/Practices
Session 5
Session 6
Debugger & Sequence Generator
Lookup caching, Sorter and Aggregator
Debug & Set break points in mapping
Sequence properties overview
Persistent, Management of cache
Theory/Demo/Practices
Theory/Demo/Practices
Session 7
Session 8
Router & Update strategy
Dynamic cache & Unconnected lookup
Router, groups, properties
Update strategy, Target update overrides
SCD type-1(Load)
Dynamic cache properties, lookup row ports
Theory/Demo/Practices
Theory/Demo/Practices
Session 9
Session 10
Mapplets, Workflow variables & tasks
Workflow task and worklets
Designer, Input/output Transformations
Variable in workflow
Different and reusable tasks
Lookup, Reusable transformations
Sorter & Aggregator, Expressions
Connected Vs unconnected, advantages
Parameter and variables
Worklets
Q&A discussion
Theory/Demo/Practices
Theory/Demo/Practices
[Link]
info@[Link]
3/297,First Floor, Foundry Road,
OMR - IT Expressway, Okkiyam Thoraipakkam
( [Link] Hotel), Chennai - 600 097.
+91 44-6455 8899 / +91 95433 22116
Informatica 9.0 Course ContentDetail
Data Integration Concepts and Terms
Router and Update Strategy Transformations
Mapping
Data Model
ETL
Transformation
Task
Workflow
Metadata
Router Transformation overview
Router Groups
Update Strategy Transformation overview
Port Default Values
Source Qualifier Overrides
Target Update Override
Session Task Override
Lab (SCD Type1 Load)
PowerCenter Transformations
PowerCenter Components and User Interface
PowerCenter Architecture & Client App
Lab
Dynamic Lookup Cache
Dynamic Lookup Cache Properties
NewLookupRow Port
Source Qualifier Transformations
Lab
Data type conversion
Homogeneous Join
Unconnected Lookup
Lab
Expression and Filter Transformations
Expression Transformation overview
Filter Transformation overview
Workflow Scheduler
Unconnected Lookup Advantages
Connected versus Unconnected Lookups
Join versus Lookups
Mapping Parameters and Variables
Lab (Fact Load)
Lab
Mapplets
Joiner Transformation
Mapplet Designer
Mapplet Input and Mapplet Output Transformations
Heterogeneous Joins
Joiner Transformation overview
Shortcuts
Lab
Mapping Design - Workshop
Lab
Lookup Transformation
Lookup Transformation overview
Pipeline Lookup
Re-usable transformations
Lab
Debugger
Debugger User Interface
Set Breakpoints
Lab
Sequence Generator Transformation
Sequence Generator overview and Properties
Lab
Workflow Variables and Tasks
Link Conditions
Workflow Variables
Assignment Task
Decision Task
Email Task
Lab
More Workflow Tasks
Event Wait Task
Event Raise Task
Command Task
Re-usable Tasks
PMCMD Utility
Lab
Lookup Caching
Worklets and More Workflow Tasks
Persistent Lookup Cache
Cache Management in mappings and sessions
Re-usable and Non-Reusable Worklet
Timer Task
Control Task
Lab
Sorter and Aggregator Transformations
Sorter Transformation overview
Aggregator Transformation overview
Aggregate Expressions
Lab
Workflow Design - Workshop
Question & Answer and discussion session