Best Informatica Training in Chennai | Informatica Training Institute in Chennai

Informatica Training

Informatica Training Institute in Chennai & Informatica Training in Chennai with Placement & Informatica Training Center in Chennai

IICT Computer Education, Chennai provides real-time and placement focused informatica training in chennai . Our informatica etl course includes basic to advanced level and our informatica course is designed to get the placement in good MNC companies in chennai as quickly as once you complete the informatica certification training course. Our informatica trainer are informatica etl certified expert and experienced working professionals with hands on real time multiple Informatica projects knowledge. We have designed our informatica course content and syllabus based on students requirement to achieve everyone's career goal. In our informatica training program, you will learn Informatica ETL tool, Informatica designer, mapping, Workflow, workflow Manager Task, Installation, Informatica Administration, Advanced features, informatica real time project and informatica etl placement training.

Our informatica etl training center is equipped with lab facilities and excellent infrastructure. We also provide informatica etl certification training path for our students in chennai. Through our informatica training center, we have trained more than 50+ informatica students and provided placement. Our informatica etl course fee is value for money and tailor-made course fee based on the each student's training requirements. Informatica training in chennai conducted on day time classes, weekend training classes, evening batch classes and fast track training classes.

Best Informatica training institute in Chennai offers hands-on Informatica training in Chennai with Placement by well experienced Informatica professionals having 12+ years of Datawarehouse experience.

We provide Informatica Training, Datawarehouse Training, ETL Testing training based on current industry standards. All our sessions are completely practical and interactive paired with Realtime Methodologies, Project Scenarios and Interview Guidance exclusively on Informatica.

Informatica is one of the widely used Data integration software available in the market today. Most of the fortune 500 companies is using Informatica as ETL Data warehousing tool.

IICT Computer Education, Chennai has been awarded as the best Informatica training institute in chennai

We teach Data Warehousing Informatica Training courses with real time scenarios and give interview guidance.

Informatica Course benefits: We are committed to provide Complete PRACTICAL Training and Complete REALTIME Training exclusively on Informatica, Cognos and Data Modelling. Study Material and Practice Material included during the course. We are proud to mention that we are the best institutes to provide Informatica COMPLETE PRACTICAL REALTIME TRAINING and hence, closely working with various companies in India amd in overseas. Most of the trainees are references from our previous students. You will get complete Hand On training for your Informatca Trainings


Informatica Training

Introduction to Data warehouse
What is Data warehouse and why we need Data warehouse
OLTP vsData warehouse
Dimensional modelling
Star schema/Snowflake schema
Dimensions / Facts tables.
Slowly Changing Dimensions and its types.
Different types of Dimensions and Facts.
Data Mart vs. Data warehouse
DWH Approaches: Ralph Kimball's vs. Bill Inmon's
E T L Informatica PowerCenter 9.x:
Introduction to Informatica PowerCenter
Informatica Architecture
PowerCenter Components


Repository Manager

Workflow Manager

Workflow Monitor


Informatica Concepts and Overview

Source Qualifier

Target Analyzer








Working with relational Sources

Working with Flat Files



Working with relational Sources

Working with Flat Files



Source qualifier transformation

Joiner Transformation

Filter Transformation

Lookup Transformation

Aggregator Transformation

Expression Transformation

Normalizer Transformation

Rank Transformation

Router Transformation

Union Transformation

Sequence Generator Transformation

Stored Procedure Transformation

Sorter Transformation

Update Strategy Transformation


Reusable mapplets and transformations
Mapping Variables & Parameters
Workflow Manger-Workflows & Sessions
Unit Testing
Interview Questions
Informatica Server and Client installation
Oracle Server installation
Case study and real time scenarios
Understanding Domains


Application Services

Using Administration Console

Managing the Domain

Managing Alerts

Managing Folders

Managing Permissions

Managing Application Services

Managing the Nodes


Managing Users and Groups
Managing Privileges and Roles

Domain Privileges

Repository Services Privileges

Reporting Service Privileges

Managing Roles - Assigning Privileges and Roles to Users and Groups


Creating and Configuring the Repository Services
Managing the Repository
Creating and Configuring Integration Services

Enabling and Disabling the Integration Services

Running in Normal and Safe Mode

Configuring the Integration Services Processes


Integration Services Architecture
Creating the Reporting Services

Managing the Reporting Services

Configuring the Reporting Services

Managing License

Advanced Workflow Module
Understanding Pipeline Partitioning

Partitioning Attributes

Dynamic Partitioning

Partitioning Rules

Configuring Partitioning


Partitioning Points

Adding and Deleting Partitioning points

Partitioning Relational Sources

Partitioning File Targets

Partitioning transformations


Partitioning Types
Real Time Processing
Commit Points
Workflow Recovery
Stopping and Aborting

Error Handling

Stopping and Aborting Workflows


Concurrent Workflows
Load Balancer
Workflow Variables

Predefined Workflow Variables

User- Defined Workflow Variables

Using Worklet Variables

Assigning Variable Values in a Worklet


Parameter and variables in Sessions

Working with Session Parameters

Assigning Parameter and Variables in a Session

Parameter File
Session Caches
Incremental Aggregation
Session Log Interface
Command Reference:
Using Command Line Programs






Designer Module
Using the Designer

Configuring Designer Options

Using Toolbars

Navigating the Workspace

Designer Tasks

Viewing Mapplet and Mapplet Reports


Working with Sources

Working with Relational Sources

Working with COBOL Sources

Working with Cobol Source Files


Working with Flat Files

Importing Flat Files

Editing Flat Files Definition

Formatting Flat Files Column


Working with Targets

Importing Target Definition

Creating Target Definition from Source Definition

Creating Target Definition from Transformations

Creating Target tables


Working with Mappings

Connecting Mapping ObjeMNC

Linking Ports

Propagating Port Attributes

Working with Targets in a Mapping

Working with Relational Targets in a Mapping

Validating a Mapping

Using Workflow Generation Wizard Mapplets

Understanding Mapplets Input and Output

Using Mapplet Designer

Using Mapplets in Mapping


Mapping Parameters and Variables
Working with User-Defined Functions
Using the Debugger

Creating Breakpoints

Configuring the Debugger

Monitoring the Debugger

Evaluating Expression


Creating Cubes and Dimensions
Using Mapping Wizard
Naming Conventions
Performance Tuning Module
Performance Tuning Overview

Using Thread Statistics

Target Bottlenecks

Source Bottlenecks

Mapping Bottlenecks

Session Bottlenecks

System Bottlenecks


Optimizing the Targets
Optimizing the Source
Optimizing the Mapping
Optimizing the Transformations
Optimizing the Sessions
Optimizing thePowerCenter Components
Optimizing the System
Using Pipeline Partitions
Performance Counters
Repository Module
Understanding the Repository
Using Repository Manager
Managing Object Permissions
Working with Versioned Object
Exporting and Importing Object
Copying Object
Transformation Module
Working with Transformations

Configuring Transformations

Working with Ports

Working with Expressions

Reusable Transformations


Aggregator Transformation
Custom Transformation
Expression Transformation
External Transformation
Filter Transformation
Joiner Transformation
Java Transformation
Lookup Transformation
Lookup Caches
Normalizer Transformation
Rank Transformation
Router Transformation
Sequence Generator Transformation
Sorter Transformation
Source Qualifier Transformation
SQL Transformation
Stored Procedure Transformation
Transaction Control Transformation
Union Transformation
Update Strategy Transformation
The Transformation Language
Creating Custom Function
Workflow Basics Module
Workflow Manager

Workflow Manager Options

Navigating the Workspace

Working with Repository ObjeMNC

Copying Repository ObjeMNC

Comparing Repository ObjeMNC


Workflow and Worklets

Creating a Workflow

Using Workflow Wizard

Assigning an Integration Service

Working with Worklets

Working with Links



Creating a Session Task

Editing a Session

Pre- and Post- Session Commands


Session Configuration ObjeMNC

Creating a Task

Configuring Tasks

Working with Command Task

Working with Decision Task

Working with Event Task

Working Timer Task

Working with Assignment Task



Configuring Sources in a Session

Working with Relational Sources

Working with Flat Sources



Configuring Targets in a Session

Working with Relational Targets

Working with File Targets

Reject Files



Validating Tasks

Validating Worklets

Validating Session

Validating Workflows


Scheduling and Running Workflows

Scheduling a Workflow

Manually Starting a Workflow


Sending Email

Working with Email Tasks

Working with Post-Session Email

Workflow Monitor

Using Workflow Monitor

Customizing Workflow Monitor Options

Working with Tasks and Workflows

Using Gantt Chart View and Task View


Workflow Monitor Details

Integration Services Properties

Workflow Run Properties

Worklet Run Properties

Session Task Run Properties

Performance Details


Session and Workflow Logs

Log Events

Log Events Window

Working with Log Files

Workflow Logs


Note: Lab sessions for all the points mentioned above will be taken.



Evolution of Datawarehousing - History
The need of Datawarehousing
Why Datawarehousing
What is Datawarehousing - The Definition

Subject -Oriented


Non - Volatile

Time Varying


Datawarehousing Architecture

Data Source Layer

Data Extraction Layer

Staging Layer

ETL Layer

Data Storage Layer

Data Logic Layer

Data Presentation Layer

Metadata Layer

System Operation Layer


Dimension table
Fact table

Additive FaMNC

Semi Additive FaMNC

Non - Additive Fact




Types of Schema

Star Schema

Snow Flake Schema

Fact Constellation Schema

Slow Changing Dimension

SCD1 - Advantages/ Disadvantages

SCD2 - Advantages/ Disadvantages

SCD3 - Advantages/ Disadvantages


Difference between OLAP and OLTP

Types Of OLAP

Multi-Dimentional (MOLAP)




Frequenty Asked Questions

1. Why Should i learn Data Warehousing from IICT ?

Data Warehousing Course at IICT is designed & conducted by Data Warehousing experts with 10+ years of experience in the Data Warehousing domain Only institution in Chennai with the right blend of theory & practical sessions In-depth Course coverage for 45+ Hours More than 15,000+ students trust IICT Affordable fees keeping students and IT working professionals in mind Course timings designed to suit working professionals and students Interview tips and training Resume building support Real-time projects and case studies.

2. Will IICT Help Me With Placements After My Data Warehousing Course Completion?

We are happy and proud to say that we have strong relationship with over 600+ small, mid-sized and MNCs. Many of these companies have openings for Data Warehousing Specialist. Moreover, we have a very active placement cell that provides 100% placement assistance to our students. The cell also contributes by training students in mock interviews and discussions even after the course completion.

3. How many students have been trained by IICT up till now?

We are proud to state that in the last 10+ years of our operations we have trained over 25,000+ aspirants to well-employed IT professionals in various IT companies.

4. How Equipped Are The Data Warehousing Faculties At IICT?

Our Data Warehousing faculty members are industry experts who have extensive experience in the field handing real-time application and completing mega real-time projects in Data Warehousing in different sectors of the industry. The students can rest assured that they are being taught by the best of the best from the Data Warehousing industry.

5. Will I Be Given Sufficient Practical Training In Data Warehousing ?

Our courseware is designed to give a hands-on approach to the students in Data Warehousing. The course is made up of theoretical classes that teach the basics of each module followed by high-intensity practical sessions reflecting the current challenges and needs of the industry that will demand the students’ time and commitment.

6. What Are The Payment Modes Accepted At IICT ?

We accept Cash, Card, Bank transfer and G Pay.

7. How old is IICT ?

More than 10 years we are into Data Warehousing Training domain. We are doing training across Chennai.

8. What certification will I receive after course completion?

You will receive IICT globally recognized course completion certification.

9. What will be the size of a Data Warehousing batch at IICT ?

We at IICT believe in giving individual attention to students so that they will be in a position to clarify all the doubts that arise in complex and difficult topics. Therefore, we restrict the size of each Selenium batch to 5 or 6 members.

10. How about group discounts (or) corporate training for our team?

Yes, IICT provides group discounts for its training programs. To get more details, visit our website and contact our support team via Call, Email, Live Chat option or drop a Quick Enquiry. Depending on the group size, we offer discounts as per the terms and conditions.


Training Experiences with Us

informatica training nazarethpettai informatica training k k nagar informatica training ashok nagar informatica training kovoor informatica training mogappair west informatica training ambattur industrial estate informatica training kundrathur informatica training pattabiram informatica training anna nagar informatica training arumbakkam informatica training poonamallee informatica training thiruverkadu informatica training maduravoyal informatica training mangadu informatica training thirumazhisai informatica training kovur informatica training madhuravoyal informatica training valasaravakkam informatica training virugambakkam informatica training sri ayyappanagar informatica training porur informatica training mugalivakkam informatica training vadapalani informatica training saligramam informatica training koyambedu informatica training nungambakkam informatica training choolaimedu informatica training saidapet informatica training raj bhavan informatica training anna university informatica training iit informatica training kotturpuram informatica training t nagar informatica training kodambakkam informatica training west mambalam informatica training tambaram informatica training tambaram iaf informatica training tambaram sanatorium informatica training perungalathur informatica training tambaram east informatica training perungalathur informatica training chitlapakkam informatica training selaiyur informatica training medavakkam informatica training madambakkam informatica training mambakkam informatica training sithalapakkam informatica training padappai informatica training pallavaram informatica training chromepet informatica training anakaputhur informatica training paruthippattu informatica training pozhichalur informatica training pammal informatica training old pallavaram informatica training kovilambakkam informatica training tiruneermalai informatica training velacheri informatica training nanganallur informatica training adambakkam informatica training madipakkam informatica training st thomas mount informatica training guindy informatica training ramapuram informatica training thoraipakkam informatica training nandanam informatica training alwarpet informatica training mandaveli informatica training adyar informatica training thiruvanmiyur informatica training besant nagar informatica training injambakkam informatica training perungudi informatica training tharamani informatica training sholinganallur informatica training navalur informatica training kelambakkam