Online Data Ware Housing Informatica Training in Virginia (VA), Richmond

Training Details

We are one of the leading top Training and Consulting Company in Online, with a good placement track record. We have certified trainers. We will provide Online Training, Fast Track online training, with job assistance.

We are providing Exclusive Training on all Software tools. Faculty from top MNCs with highly skilled domain expertise will train & guide you with real time examples, project

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


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
Reusable Transformation
Lookup Transformation
Handling Multiple Files as Source


Create Mappings
Sequence Generator Transformation
Multiple Pipelines in a Single Mapping
Target Load Plan

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

Task Link Properties
Event Raise Task
Event Wait Task
Work let


Parameter Files
Removing Duplicate Rows


Related Training Courses


java /j2ee training
.net training
bi / reporting tool
data warehousing training
project management training
business analyst it (ba) training
qa / testing tools
erp training
crm training
database training
sas training
sap training
tibco training
system admin / sys admin training
microsoft technologies training
adobe flex training
biz talk server training
visual basics training
php training
vmware training
embedded systems training training
peoplesoft training
open source training courses
ios training
web development & internet training
clinical training
websphere training
ilog jrules training
microsoft database and development
oracle database training
oracle fusion middleware training
oracle database administration training
oracle datawarehouse training
sharepoint training
biztalk training
system / network administration training
hadoop training
big data training
cloud computing training
etl training
oracle warehouse builder (owb) training
apache hadoop training
cassandra training
greenplum training
chukwa training
mongodb training
nosql training
mobile development training
open source software/web training
os environments training
weblogic training
ibm websphere mq training
ibm websphere server training
oracle soa suite training
big data hadoop development training
big data hadoop administration training
big data hadoop combo (hadoop dev, admin, nosql, solr, lucene) training
workday training
devops training
mulesoft training
blockchain training
blockchain and bitcoin training
neural networks fundamentals using tensorflow training
neural networks training
private ethereum blockchain consortium in aws using ec2 training
data science bootcamp training
comprehensive blockchain-work with multichain, ethereum in aws & azure training
ethereum developer: build a decentralized blockchain app training
tensorflow for image recognition training
learn solidity: programing language for ethereum smart training
dash crypto currency training
deep learning with tensorflow training
deep-learning-vision training
entrepreneurship training
demandware training
tableau training
informatica training
catia training
aws training
selenium training
android training
python training