Latest Updates * Offered SAP(All Modules), Oracle, Hyperion and Other Courses like Informatics, Hadoop, WebSphere, Testing Tools etc.. We are having real time industry experts as trainers. * Our SAP ,Oracle, Hyperion , Data wareHouse Online Training batches start every week and we accommodate your flexible timings.

Welcome to Online Trainings USA: Leading Global IT Online Training

Quick Enquiry

Type the characters

Please wait...


Hadoop Online Training

Java/J2EE Online Training

SAS Online Training

Android Online Training

TIBCO Online Training

Online Trainings USA is famous on-line training institute in Hyderabad India. We offer online training on various tools and technologies we have excellent trainers with good experience, We provide job oriented online classes on various Tools & Technologies. We will provide 100% project support like solving the technical issues with in the time, We also provide Corporate trainings at client location & Online, We have a development center in Hyderabad, along with training we provide projects for required candidates. we will conduct mock interviews through on-line we will guide you for the interview we will support you in resume preparation we provide . Once you register in our web site and find coaching then our trainer supports and clarifies your doubts whereas doing job. This can be the special supply to our student to become an entire software system skilled. All told, courses we offer quality coaching to our students our passion is to coach every student in real. We will train in-depth studies all told courses.

Online Trainings USA Highlights·
  • IT training in all tools & technologies (online And class-room Corporate)
  • Real-time Job support (Technical Support project level)
  • Best ideas with career development planning
  • Excellent Resume & Interview preparation
  • Promotion and Job placement with our fortune 500 clients in USA, CANADA
  • Technical support to perform day 2 day activities of your project
  • Certification examination preparation training provided
Online Trainings USA advantages
  • All our trainers are considered professionals & experts in their technologies
  • All online trainings & Corporate Trainings are Live real time instructors
  • We use the best web conferencing technology to give the high Quality Training
  • Attend the Classes from your home at your convenient timings
  • We will give you the Record option where you can record all the classes.
  • Online provides more practical approach than classroom based training
Online Trainings USA facilities
  • 24×7 365 Days Dedicated Server/System access
  • Systems/Servers will have 24/7 power backup No Down time
  • Recording Option you can view the session when ever you required
  • Excellent world-class Dedicated Conferencing Facility to organize the meetings High Quality.
  • Complete study material will be provided & Hands on Labs for each and Every session.


I have done my SAP SD Training from Online Trainings USA. It was great training effort by instructor with real time experience. - JOHN
I have undergone training on Hadoop coruse with Online Trainings USA and trainer is dedicated, committed for classes and i can recommend this institute for quality training on IT Courses. -ARUN
I did Cognos IT Training from Online Trainings USA and it was professional trainers in teaching with quality and real time industry expert and i recommend my friends to join for any IT Software training course. -ASHA

Online Training

We provide training to many people, and our members tell us that Online Trainings USA...

Corporate Training

The New Horizons Online LIVE platform effectively delivers our unrivaled Traditional...

Project Support

Learning the course is basic criteria. Apart from that to have an entire grip on the subject...

Informatica Online Training

Home  >>  Courses  >>  Data Warehouse  >>  Informatica Online Training

Informatica Online Training

Informatica  Online Training By IT Experts 

Online Training USASolutions facility offers Informatica Online Training. Our Informatica trainers come with vast work experience and teaching skills. Our Informatica training online is regarded as the one of the Best online training in India. All our students were happy and able to find Jobs quickly in USA, UK, Singapore, Japan, Europe. Informatica  training online is your one stop solution to learn Informatica at the comfort of your home with flexible schedules.

Online Training USASolutions offers the Informatica Online Course in a true global setting.

Informatica Online Training Concepts

  • Introduction to Dataware housing (What/Why/How Dataware housing)
  • Slowly Changing Dimensions (SCD1, SCD2, SCD3)
  • Metadata
  • Dimentinal Table
  • Types Of Dim Tables
  • Fact Table
  • Types of Fact Tables
  • OLTP (OnLine Transaction Processing)
  • OLAP (Online Analysis And Processing)
  • Advantages of OLAP
  • Different Methodologies of DWH

PowerCenter Components and User Interface

  • 1.Informatica PowerCenter Architecture
    • 2.Informatica PowerCenter Client Tools
    • 3.Start Using of the Designer, Workflow Manager and Workflow Monitor

Source Qualifier

  • 1.Source Qualifier Transformation
    • 2.SQLoverride in source qualifier transformation
    • 3.Source qualifier transformation joins concept
    • 4.Source qualifier transformation on Relational Databases
    • 5.Source qualifier transformation on File systems
    • 6.Source qualifier transformation filter concepts
    • 7.Difference Between SQL Override, Other Options
    • 8.Source Qualifier Transformation Performance Tunning
    • 9.Pre SQL and Post in Source Qualifier Transformation

Expression, Filter, File Lists and Workflow Scheduler

  • 1.Expression Editor
    • 2.Filter Transformation
    • 3.File Lists
    • 4.Workflow Scheduler
    • 5.Lab – Load the Customer Staging Table and Real time issues

Joins, Features and Techniques I

  • 1.Joiner Transformation
    • 2.Shortcuts
    • 3.Lab A – Load Sales Transaction Staging Table
    • 4.Lab B – Features and Techniques I and Real time issues

Lookups and Reusable Transformations

  • 1.Lookup Transformation
    • 2.Reusable Transformations
    • 3.Lab A – Load Employee Staging Table
    • 4.Lab B – Load Date Staging Table and Real time issues


  • 1.Debugging Mappings
    • 2.Lab – Using the Debugger

Sequence Generator

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

Lookup Caching, More Features and Techniques

  • 1.Lookup Caching
    • 2.Lab A – Load Promotions Dimension Table
    • 3.Lab B – Features and Techniques II
    • 4.Review and more Lab Activities and Real time issues

Router, update Strategy and Overrides

  • 1.Router Transformation
    • 2.Update Strategy Transformation
    • 3.Expression Default Values
    • 4.Source Qualifier Override
    • 5.Target Override
    • 6.Session Task Mapping Overrides
    • 7.Lab – Load Employee Dimension Table and Real time issues

Dynamic Lookup and Error Logging

  • 1.Dynamic Lookup
    • 2.Error Logging
    • 3.Lab – Load Customer Dimension Table

Unconnected Lookup, Parameters and Variables

  • 1.Unconnected Lookup Transformation
    • 2.System Variables
    • 3.Mapping Parameters and Variables
    • 4.Lab – Load Sales Fact Table

Sorter, Aggregator and Self-Join

  • 1.Sorter Transformation
    • 2.Aggregator Transformation
    • 3.Active and Passive Transformations
    • 4.Data Concatenation
    • 5.Self-Join
    • 6.Lab – Reload the Employee Staging Table and Real time issues

SCD type1 – Hands-On LAB

SCD type2 – Hands-On LAB

SCD type3 – Hands-On LAB


  • 1.Mapplets
    • 2.Lab – Load Product Daily Aggregate Table
    • 3.Review and more Lab Activities and Real time issues

Workflow Variables and Tasks

  • 1.Link Conditions
    • 2.Workflow Variables
    • 3.Assignment Task
    • 4.Decision Task
    • 5.Email Task
    • 6.Lab – Load Product Weekly Aggregate Table

More Tasks and Reusability

  • 1.Event Raise Task
    • 2.Event Wait Task
    • 3.Command Task
    • 4.Reusable Tasks
    • 5.Reusable Session Task
    • 6.Reusable Session Configuration

Worklets and More Tasks

  • 1.Worklets
    • 2.Timer Task
    • 3.Control Task

Our Informatica Online Training batches start every week and we accommodate your flexible timings.



Course Details:

Duration :  45-50 hours(Daily 1hr to 1 hr 30 minutes)
System Access:  5 months
Session Timings: As per participant convenience
Payment Options:  Online

About Trainer:

Online Training USAtrainers are passionate and focused in quality and accuracy for delivering the best services for our clients. Our trainers are from top MNCs and carry years of experience. The training methodology is not just walking through people with PPTs, rather it is way to share experienced they gain over many years. Our trainer evaluation method is very rigorous and people qualify with predefined parameters are only eligible to train and associate with Amaravati Info Solutions. Online Training USAtraining quality parameters are very high and we are very concern about the quality delivery. Our trainers are educated with Online Training USAtraining standard and ensure that there is no way we compromise with quality at any point.

[/tabcontainer] [/tabwrapper]

Request Free Demo

Please fill the below details, we will mail you more info.

Please wait...