Courses » Datawarehouse Online Training » Informatica Online Training

 

Informatica Online Training

 

Introduction and Architecture

Introduction to Informatica

Architecture of Informatica — Power Center 8.1
Informatica Design Process
Informatica Client Tool — Designer
Source Analyzer and Warehouse Designer

Mapping Designer

Create a Simple Mapping
Overview of Transformations
Types of Transformations — Active and Passive
Expression Transformation
Source Qualifier Transformation
Introduction to Workflow Manager
Control Flow Statements
Task Developer
Workflow Designer
Creating Connections
Flat Files Handling
Create Simple Mappings
Flat File Analysis

Architecture Review

Architecture 8.1 Review
Differences between Power Mart and Power Center
Connecting to SAP
FTP Process
Command Task
Create a Mapping
Joiner Transformation

Transformations

Create a Mapping

Using Join in a Source Qualifier Transformation
Expression Transformation
Filter Transformation
Transformations Contd

Multiple Targets Loading

Router Transformation
Diff between Filter and Router Transformations
Create a Mapping
Master Outer Join

Transformations Contd

Create a Mapping
CReusable Transformation
CLookup Transformation
CDebugger
CHandling Multiple Files as Source
CMapplets
CCreate Mappings
CSequence Generator Transformation
Multiple Pipelines in a Single Mapping
Target Load Plan
Mapplets

Update Strategy

SCD Type 1 mapping Implementation
Update Strategy Transformation
SCD Type 2
SCD Type 2 mapping Implementation
Loading Strategy
Sequential and Parallel Loading

Union Transformation
Dynamic Lookup Cache
Introduction to Fact Loading
Create a Mapping

Transformations Contd

Create a Mapping
Date Dimension Loading
Lookup Transformation – Persistent Cache
Aggregator Transformation
Sorter Transformation
Creating Stored Procedure

Transformations Contd

Normalizer Transformation
Stored Procedure Transformation
Active Vs Passive Transformations
Connected Vs Unconnected Transformations

Implementing Incremental Loading

Create a Mapping
Importance of Mapping Variable
Implementing Incremental Aggregation
Create a Mapping
Incremental Aggregation
Transaction and Variable Port
Transaction Control Transformation
Variable Ports
Workflow Tasks
Scheduling

Task Link Properties
Event Raise Task
Event Wait Task
Work let

Others

Parameter Files

Removing Duplicate Rows