Informatica Certification Training in Chennai & Informatica Certification Training institutes in Chennai & Informatica Certification Training institute in Chennai & Informatica Certification Training Centers in Chennai

Informatica Certification Training in Chennai with vast experienced Expert. IICT Chromepet (Informatica Certification Training in Chennai) offers best Informatica Certification Training in Chennai with 15+ years of experienced professionals.

Informatica Certification Training institute in Chennai & Informatica Certification Training in Chennai with Placement & Informatica Certification Training Center in Chennai & Informatica Certification Training with Placement in Chennai

Informatica Certification Training in Chennai , Informatica Certification Training institute in Chennai

IICT provides 100% real-time, practical and placement focused Informatica Certification Training in Chennai. Our Informatica Certification course concentrates from basic level training to advanced level training. Our Informatica Certification Training in completely focused to get placement in MNC in Chennai and certification on Informatica Certification after completion of our course. Our team of Informatica Certification trainers are Informatica Certification certified professionals with more real-time experience in live projects. Our Informatica Certification Course syllabus covers basic to advanced level of the program along with the live examples.

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

Admission Procedure for Informatica Certification Training @ IICT, Chennai

  • Needed Students only with basic Computer Science Background

  • Passport size photograph for life time support ID

  • Address proof & ID Proof

  • Emergency Contact Number

  • Informatica Certification Training Course Syllabus in Chennai

    Informatica syllabus covered by MNC Expert is completely in real time and industry based syllabus which are used in real time.

    100% Real Time Informatica Course Content Designed by MNC Expert who is Certified in Informatica.

    Data Warehouse Concepts:

    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

    Administrator Module

    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

    Transformation Language Reference:

    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

    OLAP and OLTP

    Difference between OLAP and OLTP

    Types Of OLAP

    Multi-Dimentional (MOLAP)



    Informatica Certification Training in Chennai Benefits

  • Real Time Trainers

  • 100% Placement Assistance

  • Small Training Batch

  • Flexible Timings

  • Practical Guidance

  • Excellent Lab Facility

  • Informatica Certification Resume Preparation

  • Hands on Experience

  • Informatica Certification Certification Support

  • Life Time Support will be provided

  • Materials will be provided and Informatica Certification software will be provided

  • Informatica Certification course materails and interview question will be provided

  • After regular Class hours 24/7 support provided for Practice

  • Regular assignments and Informatica Certification real time tasks will be provided

  • Informatica Certification Training batch size in Chennai

    Regular Batch ( Morning, Day time & Evening)

  • Seats Available : 5 (maximum)

  • Weekend Training Batch( Saturday, Sunday & Holidays)

  • Seats Available : 4 (maximum)

  • Fast Track Batch (4+ Hours daily)

  • Seats Available : 3 (maximum)

  • Informatica Certification Training Location in Chennai

    Our Informatica Certification Training center

    Contact Us

    No.14/22, Third Floor,
    First Cross Street, Newcolony,
    Chrompet, Chennai- 600 044.

    Land Mark: Near Chrompet Railway Station and Bus Stop,
    Behind Sri Krishna Sweets.

    Mobile: 90038 53466

    Informatica Certification Corporate Training in Chennai

    Our Corporate training programs feature:

  • Customized training programs

  • Flexible Training Schedule - courses can be delivered at your chosen convenient time.

  • Hands-on training

  • Flexible group size

  • Affordable Price

  • Most advanced Training Resources - structured course material, learning CDs, highly experienced and certified faculty members.

  • Video Tutorials will be provided and Informatica Certification software will be provided

  • Informatica Certification Online Training in Chennai

  • Custom lessons with specific terminology and examples from your business

  • Designed and developed from scratch with your employees in mind

  • Simulations are based on your Informatica Certification system, mirroring your exact system version, configuration and business processes

  • Courses can be organized by business process or job role and include any functionality that you desire.

  • Informatica Certification Training in Chennai Support

  • Mobile : 90038 53466

  • Informatica Certification Placement Training in Chennai

  • More than 2000+ students Trained

  • 90% percent Placement Record

  • 500+ Interviews Organized

  • Informatica Certification Related Training Courses in Chennai

    Oracle SQL Training in Chennai

    Oracle PL/SQL Training in Chennai

    Oracle DBA Training in Chennai

    Informatica Training in Chennai

    Cognos Training in Chennai

    Datastage Training in Chennai

    ETL Testing Training in Chennai

    Datawarehousing Training in Chennai

    Oracle Training in Chennai

    Oracle RAC Training in Chennai

    Qlikview Training in Chennai

    Microstrategy Training in Chennai

    Teradata DBA Training in Chennai

    Performance Tuning Training in Chennai

    OBIEE Training in Chennai

    SQL Server DBA Training in Chennai

    Oracle Fusion Middleware Training in Chennai

    SOA Admin Training in Chennai

    Oracle Identity Manager Training in Chennai

    OSB 11g Training in Chennai

    Oracle ADF Training in Chennai

    Hyperion Planning Training in Chennai

    Hyperion Financial Training in Chennai

    Oracle Forms and Reports Training in Chennai

    ODI Training in Chennai

    Oracle Essbase Training in Chennai

    PeopleSoft Finance Training in Chennai

    PeopleSoft HCM Training in Chennai

    Weblogic Server Training in Chennai

    Business Objects Training in Chennai

    Cognos TM1 Training in Chennai

    Big Data Analytics Training in Chennai

    Informatica Data Quality Training in Chennai

    Hadoop Training in Chennai

    Ab Initio Training in Chennai

    Microsoft BI Training in Chennai

    Oracle Apps Finance Training in Chennai

    Oracle Apps HRMS Training in Chennai

    Oracle Apps SCM Training in Chennai

    Oracle Apps Technical Training in Chennai

    DB2 DBA Training in Chennai

    Latest Reviews of IICT- " Students Are Brand Ambassadors "

    Road Map of IICT

    IICT Chromepet Address, IICT Contact, IICT Location, IICT Chrompet address, IICT Chennai Address, IICT

    IICT - Chrompet Head Office

    Click Here For Google Map

    Are you located in any of these areas - Abiramapuram, Adambakkam, Adyar, Agaram, Alandur, Alwarpet, Alwarthirunagar, Ambattur, Ambattur Industrial Estate, Aminjikarai, Anakaputhur, Anna Nagar, Anna Nagar East, Anna Nagar West, Anna Salai, Arumbakkam, Ashok Nagar, Avadi, Ayanavaram, Besant Nagar, Broadway, Chengalpet, Chennai Others, Chetpet, Chintadripet, Chitlapakkam, Choolai, Choolaimedu, Chromepet, Egmore, Ekkaduthangal, Ennore, Flowers Road, George Town, Gopalapuram, Gowrivakkam, Guduvanchery, Guindy, Iyyapanthangal, Jafferkhanpet, Jawahar Nagar, K.K. Nagar, Kattupakkam, Kellys, Kilpauk, Kodambakkam, Kodungaiyur, Kolathur, Korattur, Korrukupet, Kottur, Koyambedu, Kundrathur, M.K.B. Nagar, Madhavaram, Madipakkam, Manali, Manapakkam, Mandaveli, Mangadu, Maraimalai Nagar, Medavakkam, Meenambakkam, Minjur, Mogappair, Mogappair East, Moulivakkam, Mudichur, Mylapore, Nandambakkam, Nandanam, Nanganallur, Neelangarai, Nungambakkam, Old Washermenpet, Orgadam, Padi, Palavakkam, Palavanthangal, Palavayal, Pallavaram, Pallikaranai, Pammal, Park Town, Parrys, Pattabiram, Perambur, Periyar Nagar, Perungalathur, Perungudi, Poonamallee, Porur, Potheri, Pozhichalur, Pudupet, Purasawalkam, Puzhal, R.A. Puram, Redhills, Royapettah, Saidapet, Saligramam, Santhome, Selaiyur, Sembiam, Shenoy Nagar, sholavaram, Sholinganallur, Singaperumalkoil, Sowcarpet, Sri Iyappa Nagar, St. Thomas Mount, T. Nagar, Tambaram, Teynampet, Thiruninravur, Thiruvanmiyur, Thiruverkadu, Thiruvotriyur, Thousand Lights, Tondiarpet, Triplicane, Urapakkam, Vadapalani, Valasaravakkam, Vandalur, Velachery, Vepery, Villivakkam, Virugambakkam, Vyasarpadi, Washermanpet and West Mambalam

    IICT Training is NOT affiliated or associated with SAP AG. IICT Training does NOT sell or distribute any SAP Copyrighted materials or software. IICT Training does NOT provide SAP IDES Access. IICT Training is NOT an official Training Partner of SAP AG.

    RSS Sitemap   |   Sitemap  ©IICT, CHENNAI , TN. All rights reserved.