Informatica Training

Best Software Training Institute in Chennai

Informatica Training in Chennai

Informatica Training in Chennai

Our Informatica Training in Chennai aims to teach the complete Data Warehousing Concepts in a easier way. We are the Best Informatica Training Institute in Chennai in-terms of syllabus and expert teaching. We are covering almost all the transformations which is required for companies in Informatica.

Upcoming Batches

Starts Duration Days Time (IST)
11th Feb 6 Weeks Sat & Sun 03:00PM – 06:00PM
13th Feb 4 Weeks Mon – Fri 07:30AM – 09:00AM
18th Feb 6 Weeks Sat & Sun 12:30PM – 03:30PM
20th Feb 4 Weeks Mon – Fri 08:00AM – 09:30AM
25th Feb 6 Weeks Sat & Sun 10:00AM – 01:00PM
27th Feb 4 Weeks Mon – Fri 06:30PM – 08:00PM
04th Mar 6 Weeks Sat & Sun 04:00PM – 07:00PM
06th Mar 4 Weeks Mon – Fri 06:30PM – 08:00PM
Schedule does not suit you, contact us now! | Want to take one-on-one training, contact us now!

Informatica® is one of the leading data integration software available in the IT market today.

Each passing day, more and more companies are joining the Informatica band wagon for achieving Data Warehousing through ETL.

Informatica is one of the most widely used ETL tools for data warehousing and business intelligence. This is the tool that provides DW solution to more than 70% of all DWBI projects today. Informatica is emerging in the market and overcoming all challenges of DWBI compared to any of its competitors.

If you are looking forward to a promising career in DWBI look no further this is your tool and we are your destination.

Informatica® is one of the fastest growing ETL tools and is way ahead in terms of market and business than any other ETL tool today.

Here at Besant Technologies we will help you master this tool with interactive sessions. The advantage of mastering Informatica® here is that, the sessions will be covered by faculty working in live ETL projects thus giving you an insight into how this ETL tool used in today’s business.

So if you are looking for a promising IT career for a long time, then look no further, ETL is your answer and Besant Technologies is your solution.

Please feel free to contact us for any further queries and we will connect you with our faculty.

Informatica Training Syllabus

Data Warehouse Introduction

Power Center Components

  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
  • Power Center Admin Console

Informatica Concepts and Overview

  • Informatica Architecture.

Sources

  • Working with relational Sources
  • Working with Flat Files

Targets

  • Working with Relational Targets
  • Working with Flat file Targets

Transformations – Active and Passive Transformations

  • Expression
  • Lookup –Different types of lookup Caches
  • Sequence Generator
  • Filter
  • Joiner
  • Sorter
  • Rank
  • Router
  • Aggregator
  • Source Qualifer
  • Update Strategy
  • Normalizer
  • Union
  • Stored Procedure
  • Slowly Changing Dimension
    • SCD Type1
    • SCD Type2 — Date, Flag and Version
    • SCD Type3

Workflow Manger

  • Creating Reusable tasks
  • Workflows, Worklets & Sessions
  • Tasks
    • Session
    • Decision task
    • Control Task
    • Event wait task
    • Timer task
  • Monitoring workflows and debugging errors

Indirect Loading

Constraint based load ordering

Target Load plan

Worklet ,Mapplet ,Resuable transformation

Migration –XML migration and Folder Copy.

Scheduling Workflow

Parameter and variables

XML Source, Target and Transformations

Performance Tuning

  • Pipeline Partition
  • Dynamic Partition
  • Pushdown optimization

We have weekly demo classes for Informatica, do feel free to give us a call and drop in.

Informatica Training Reviews

Besant Technologies Reviews given by our students already completed the training with us. Please give your feedback as well if you are a student.

Best Informatica Training in Chennai – Review by Raja Praveen.N


I am Raja Praveen.N. As I have IT experience I liked to improve my skills. For Database stuffs ,I knew SQI,PISQI & Unix shell scripting. However in my organization, they used informatica & OBIEE with oracle PISQL. Moreover as the scope of informatica is being rising day by day.I joined in Besant Technologies. Tutor Mr.Ismail taught very well. With the help of him ,I learnt informatica technology. While teaching of transformation, he gave the exercise to slove it,so I felt the realtime work experience while doing exercise.As he said me to work independently, I faces Vast number of problems,& I able to resolve it by myself.it helped to think & work independently. Overall Mr.Ismail is the best tutor. Due to him I could spent time in the morning for learning Informatica.I rate 10/10 for his Teaching.

Informatica Training in Chennai – Review by Hemavathi


It was good learning session and the classes are practical.The practical classes was useful her getting the proper knowledge on the tool.I understood the basic concepts of informatical ETL tool.The Tasks was given after the completion of each topic,to improve the technical skil on that concepts.thanks to besant technologies and thanks to ismail.

Informatica Course in Chennai – Review by Vanitha


The Training was very practical .I understand the basic concepts of informatica tool.Thanks for your great effort to make us learn informatica in slow and easier way.It was really helpful,and cleared even my smallest doupts.

Besant Technologies Velachery

No. 24, Nagendra Nagar,
Velachery Main Road,
Velachery, Chennai - 600 042
Tamil Nadu, India
Landmark - Opposite to Phoenix Market City

+91-996 252 8293 | 996 252 8294

Besant Technologies Tambaram

No. 31 / 11, Govindarajan Street,
West Tambaram,
Chennai - 600 045
Tamil Nadu, India
Landmark - Behind National Theatre

+91-996 250 4283

Besant Technologies OMR

No. 5/318, 2nd Floor, Sri Sowdeswari Nagar,
OMR, Okkiyam Thoraipakkam,
Chennai - 600 097
Tamil Nadu, India
Landmark - Behind Okkiyampet Bus Stop, Above IBACO Ice Cream

+91-887 038 4333

Besant Technologies Bangalore

No. 5 / 3, 2&3rd floor ,
Varathur Main Road,
Kundalahali Gate Bus Stop,
Bangalore - 560 066
Karnataka, India
Landmark - Opposite to SKR Convention Hall

+91-951 333 2301 / 02

Quick Enquiry