Job Meter = High
Informatica Powercenter
60 Hours
Online Instructor-led Training
USD 168

About this Course
Informatica Powercenter
Course Details & Curriculum
Informatica 9.6.1 Course Structure
Introduction
Introduction to ETL
ETL - Process
Introduction to Informatica Powercenter
Pwercenter Architecture
Overview of Informatica Components
Informatica Design Process, Open Database Connectivity
(ODBC)
Configuring Informatica Client Tools
Overview of the Databases
Informatica Design Process
Source Analyzer
Relational Source
Open Database Connectivity (ODBC)
Target Designer
Relational Target
Design Mapping, Transformation
Mapping
Transformations
Source Qualifier Transformation
Expression Transformation
Session , Workflow, Relational Connections, Workflow Monitor
Workflow Manager Client Tool
Task Developer
Workflow Designer
Connections
Worflow Monitor- Session Log File
Execution Process, Source Qualifier – Join, Filter
Execution Process
PowerCenter Components and User Interface
Introduction to Informatica
PowerCenter Architecture
Overview of Informatica Components
Source Qualifier Transformation – Join, Filter
Source - Flat File, Join – Two Flat Files
Source – Flat File
Joiner Transformation
Joiner Transformation - Join Type’s –(a. Normal Join, b. Master Outer Join, c. Detail Outer Join, d. Full Outer Join )
Joiner, Types of Joins, Union
Union Transformation
Multiple Targets - Filter, Router, Normalizer
Single Row into Multiple Rows - Normalizer, Aggregator
Normalizer Transformation
Aggregator Transformation
Aggregator, Sorter, Rank, Update Strategy
Performance Tunning - Aggregator Transformation
Sorter Transformation
Rank Transformation
Update Strategy Transformation
Sequence Generator, Stored Procedure, Active & Passive Transformations, Connected & Unconnected Transformations
Sequence Generator Transformation
Stored Procedure Transformation
Active and Passive Transformations
Connected and Unconnected Transformations
Expression Transformation
Lookup, Debugger
Lookup Transformation
Debugging Mapping
Lookup Transformation, Router, Update Strategy Transformations
Advance Topics
Dynamic Lookup Cache
Unconnected Lookup Transformation
Constraint Based Load Ordering
Session Failed
Incremental Loading – Mapping Variable
CASE STUDY
Implementation Methodology
Implementation Process of an Data Warehouse / Data Mart Project
Development / Testing / Production Environment
Staging, Dimension Load
Dimension – Load - SCD Type 1
Dimension – Load - SCD Type 3
Dimension – Load – SCD Type 2
Using Flag
Using Version
Using Datetime
Staging, Dimension , Sequential / Parallel – Load
Fact Load, Time Dimension, Surrogate Keys
Loading Strategy
Reusable Transformation, Mapplet
Assignment Task,Raise event, Command Task, Email Task, Worklets and Other Tasks
Command Task, Email Task
Worklets
Link Conditions
Event Raise, Event Wait
Workflow Scheduler
FAQ
Will this course help me clear the certification exam? +
Which is better - Self-paced training or Instructor-led training? +
Who are the trainers? +
What if I miss a class? +
How will I execute the practical? +
Is the course material accessible after completion of the course? +
Is there any offer/discount that I can avail? +
Will I get a refund if I cancel my enrollment? +
What if I have queries after completion of the course? +