Informatica PowerCenter 9.x Developer Track Course at Marath

Informatica PowerCenter 9.x Developer Track

Course Objectives
After successfully completing this course, students should be able to:
Use PowerCenter 9.x Designer to build mappings that move data from sources to targets
Use PowerCenter 9.x Workflow Manager to build and run a workflow that runs a session based on a mapping
Design mappings and workflows based on business needs
Perform basic troubleshooting of PowerCenter mappings and transformations
Use Informatica Support options to resolve questions and problems about Informatica PowerCenter 9
Introducing the need of ETL
Overview of Informatica Architecture
Client tools and Server tools and Create ,Manage and Edit Objects
Powercenter Designer
Importing Source file/Target File ( Fixed width, Delimted) and File Properties
Build mapping to load data from flat files
Powercenter Workflow Manager and Monitor
Session Properties
Creation of Workflow Task ( Session) and use it Workflow
Lab Importing File Definition Using Designer
Filter Transformation
Filter Properties
Difference between Source Qualifier
Filter and Filter Transformation
Lab Session
Router Transformation
Overview
Working with Groups
Working with Ports
Connecting Router Transformations in a Mapping
Creating a Router Transformation
Difference between Router and Filter
Lab Session
Sorter and Aggregator
Sorter, Aggregator and Self Join
Sorter Transformation
Aggregator Transformation
Active and Passive Transformations
Data Concatenation
Self-Join
Lab Session
Rank Transformation
Overview
Ports in a Rank Transformation
Defining Groups
Creating a Rank Transformation
Lab Session
Joiner Transformation
Joins, Features and Techniques I
Joiner Transformation
Shortcuts
Lab Session
Union Transformation
Working with Groups and Ports
Creating a Union Transformation
Using a Union Transformation in a Mapping
Debugger & Debugging Mappings
Lab Session
Lookups and Reusable Transformations
Lookup Transformation
Reusable Transformations
Lookup Caching
Lab Session
Sequence generator Transformation
Overview
Common Uses
Sequence Generator Ports
Transformation Properties
Creating a Sequence Generator
Transformation
Lab Session
Load Strategies
Truncate and Load
Insert Only
Update Only
Update else Insert/Insert Else Update
Lab Session
Update Strategy and Overrides
Update Strategy Transformation
Expression Default Values
Source Qualifier Override
Target Override
Session Task Mapping Overrides
Lab Session
Working with SCD Type1 and Type2
Introducing SCDs, type 1, 2 & 3
Implementing type 1
Implementing type 2
Lab Session
Dynamic Lookup and Error Logging
Dynamic Lookup
Error Logging
Unconnected Lookup
Unconnected Lookup Transformation
Lab Session

For More Details contact us:

Elegant It Services
contact no:9886541264
Email:[email protected]
Website:www.ele
gantitservices.com