Price: 1.00 ₹


Best Informatica training in Chennai – Contact Dinesh @  9840496320 /  9940516384 / 044-43511623

Demo class Available on All days


My training tends towards real time requirement as well as interview / certification point of view.


About myself

I work as a Senior Data warehousing consultant for a Leading MNC in Chennai with 9+ years experience in both software development and training.


Qualification: B.E., MIS (USA), PMP


Informatica Professional Certification

Informatica Certified Administrator

Informatica Certified Designer

Informatica Certified Consultant

Data Integration, focused on PowerCenter product suite

Data Quality, focused on Data Quality product suite

MDM, focused on MDM Hub configuration

Velocity, focused on project implementation methodology


My training benefits

•My batch sizes are generally very small size 3-4 members OR 1 to 1 also, so students receive direct, hands-on training from us.

•100% practical training only. It is not a slide show training program / theory class program. At the end of this class, definitely you will refer your colleagues / friends / relatives for my training.

•Conducting regularly online- training for US peoples in all time zones (PST,CST,EST,HST,MST)

Please reach out to me for any further clarification.

Fast track available


Contact:  Dinesh Jaganathan

044-43511623 /  9840496320 /  9940516384



Informatica training in chennai |Informatica  course in chennai |Informatica  institute in chennai | Informatica training Institute in Chennai Adyar


About Informatica Training

Introduction to Data warehousing

Overview of a OLTP/Transactional system

Forms of Normalization

Pros/Cons of having an OLTP system in real time reporting.

Need of a data warehouse.

Data warehouse layer architecture.

Designing a warehouse using Star/Snowflake schemas.

Logical/Physical Models in Erwin

Introduction to Informatica/ETL tools

The role of ETL tools in data warehousing.

An introduction to Informatica

Informatica Architecture

Components/Process flow

Informatica Designer

Basic Concepts

Using the designer.

Working with the Sources-Source Analyzer

Working with Relational/Flat file targets- Warehouse Designer.

Defining Keys in Informatica.

Working with Transformations –Transformation Developer

Working with Mapplets- Mapplet designer.

Creating mappings –Mapping Designer.

Understanding Pipelines in mappings.

Setting Target Load order.

Configuring Constraint Based loading.

Introduction to Mapping Parameters/Variables.

Implementing Type1, Type2, and Type3 Mappings.

Loading Fact tables.

Working with Transformations

Active/Passive Transformations

Caching concepts in Informatica.

Connected/Unconnected Transformation

Importance of Source Qualifier.

Filter, Router


Sorter, Aggregator




Stored Procedure

Sequence generator


Transaction Control

Update Strategy

Xml transformation


Creating Workflows

Understanding the server Architecture

Working with Workflows

Working with Tasks Assignment,Command,Decision,Control,Event raise,

Event Wait,Timer,Email,Session Task

Working with Work lets

Working with Sessions

Understanding Commit Points

Recovering Data

Monitoring Work flows

Using Multiple Servers

Log files

Row Error Logging

Session parameters

Parameter files

Using Incremental Aggregation

Real-Time Implementation with Informatica

Performance Tuning(With Real time Examples).

Using Incremental Aggregation

Extraction modes(Pull, Push).

Change Data capture concepts.

Incremental Extraction using control tables..

Session parameters and variables.

Session and Workflow properties Reference.

Pipeline partitioning.

Using Multiple Servers, Log files, Error, Row logging

Session Recovery.

Configuring Session caches lookup, Aggregate, Sort, Joiner caches.

Restart able Tables.

Reject Capture and Reprocessing.

Handling SoftHard Rejects.

Duration : 45 Working hours (Practical not Included)


More Details

Total Views:7
Reference Id:#107152
Phone Number:9840496320
Website URL:Click To Visit
Current Rating: 5.0/5 2 Vote
Copyright © 2019 |   All Rights Reserved | |   24x7 support |   Email us : info[at]