IICT ACADEMY

Informatica Training in Chennai & Best Informatica Training Institute in Chennai & Informatica Course in Chennai


IICT 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 trainers are Informatica etl certified experts 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.

IICT Chennai offers Informatica training with choice of multiple training locations across Chennai. Our Informatica ETL training centers are equipped with lab facilities and excellent infrastructure. We also provide Informatica ETL certification training path for our students in Chennai. Through our associated Informatica training centers, we have trained more than 500+ 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.


Informatica 9.1 training course content and Syllabus in Chennai


INTRODUCTION TO DATAWAREHOUSING

DATAWAREHOUSING CONCEPTS

  • Data Warehousing Concepts
  • Dataware housing (what/Why/How)
  • Data Modelling(Schemas, FACTS and DIMENSIONS)
  • Slowly Changing Dimensions o Metadata and Data marts
  • Data Ware housing Architecture


Repository Manager

  • Creating Folder
  • Granting Rights, Access, Privileges
  • Create user, groups, Roles
  • Managing the folders


PowerCenter Components and User Interface

  • PowerCenter Architecture
  • PowerCenter Client Tools
  • Lab – Using the Designer and Workflow Manager


Power Center Designer


  • Extraction for data from Database and loading into Database
  • Flat file extraction to Database
  • Extraction from Xml file to Database
  • Importing Source metadata
  • Designing the Target warehouse


Source Qualifier and XML Source Qualifier

  • Source Qualifier Transformation
  • Lab Project Overview
  • Lab A – Load  Staging Table
  • Source qualifier Joins
  • Lab B – Load Staging Table
  • Source Pipelines
  • Lab C – Load Customer Staging Table and Real time issues


Expression, Filter, File Lists and Workflow Scheduler

  • Expression Editor
  • Filter Transformation
  • File Lists
  • Workflow Scheduler
  • Lab – Load the Customer Staging Table and Real time issues


Joiner, Features and Techniques

  • Joiner Transformation
  • Lab A – Load Employee Staging Table
  • Lab B – Features and Techniques I and Real time issues


Lookups and Reusable Transformations

  • Lookup Transformation
  • Lab A – Load Employee Staging Table
  • Lab B – Load Date Staging Table and Real time issues


Debugger

  • Debugging Mappings
  • Lab – Using the Debugger


Sequence Generator

  • Sequence Generator Transformation
  • Lab – Load Date Dimension Table and Real time issues


Lookup Caching, More Features and Techniques

  • Lookup Caching
  • Lab A – Load Customer Dimension Table
  • Lab B – Features and Techniques II
  • Review and more Lab Activities and Real time issues


Router, update Strategy and Overrides

  • Router Transformation
  • Update Strategy Transformation
  • Expression Default Values
  • Source Qualifier Override


Target Override

  • Session Task Mapping Overrides
  • Lab – Load Employee Dimension Table and Real time issues


Dynamic Lookup and Error Logging

  • Dynamic Lookup
  • Error Logging
  • Lab – Load Customer Dimension Table


Connected and Unconnected Lookup, Parameters and Variables

  • Unconnected Lookup Transformation
  • System Variables
  • Mapping Parameters and Variables
  • Lab – Load Sales Fact Table


Sorter, Aggregator  

  • Sorter Transformation
  • Aggregator Transformation
  • Active and Passive Transformations
  • Data Concatenation
  • Lab – Reload the Employee Staging Table and Real time issues


Slowling Changing Dimension- SCD type1 – LAB
Slowling Changing Dimension -SCD type2 – LAB
Slowling Changing Dimension -SCD type3


Transformation Developer

  • Creating Reusable Transformation in Transformation Developer
  • Creating Reusable Objects in Mapplets Designer.


Mapplets Designer

  • Mapplets
  • Lab – Load Table
  • Review and more Lab Activities and Real time issues


Workflow Manager

  • Working with Task Developer
  • Creating Task and assigning to Mapping
  • Creating Workflow and Executing the workflow
  • Session Properties and Realtime Issues
  • Partition Technique


Workflow Variables and Tasks

  • Workflow Variables
  • Assignment Task
  • Decision Task
  • Email Task


More Tasks and Reusability

  • Event Raise Task
  • Event Wait Task
  • Command Task


Worklets and More Tasks

  • Worklets
  • Timer Task
  • Control Task


WorkFlow Monitor

  • Monitoring the session and workflow.
  • Troubleshooting the errors.
  • Checking log property.
  • Checking the output with session log.
  • Checking the Performance statistics.


Informatica training duration in Chennai


Regular Classes( Morning, Day time & Evening)

Duration : 20 days

Weekend Training Classes( Saturday, Sunday & Holidays)

Duration : 6 Weeks

Fast Track Training Program( 5+ hours daily)

Duration : within 5 days


Informatica trainer Profile & Placement


Our Informatica Trainers

More than 8+ Years of experience in Informatica Technologies
Has worked on 10 realtime Informatica projects
Working in a MNC company in Chennai
Trained 500+ Students so far.
Strong Theoretical & Practical Knowledge
Informatica certified Professionals


Informatica (informatica etl) Placement Training in Chennai


More than 500+ students Trained
98% percent Placement Record
100+ Interviews Organized
Placement Supported


Informatica training Locations in Chennai


Our Informatica ETL Training centers


Adyar
Ambattur
Adambakkam
Anna Nagar
Anna Salai
Ashok Nagar
Choolaimedu
Chromepet
Ekkattuthangal
Guindy
Kodambakkam
Madipakkam
Mylapore
Porur
Saidapet
T. Nagar
Tambaram
Vadapalani
Velachery
Villivakkam
Virugambakkam


Informatica training batch size in Chennai


Regular Batch ( Morning, Day time & Evening)

Seats Available : 5 (maximum)

Weekend Training Batch( Saturday, Sunday & Holidays)

Seats Available : 5 (maximum)

Fast Track batch

Seats Available : 5 (maximum)


Informatica Related Training Courses:


ETL Testing Training in Chennai


Hadoop Training in Chennai


Datwarehousing Training in Chennai


Cognos Training in Chennai


Datastage Training in Chennai