Call Us: +91-99495-33324 Land Line: 040-40208208
Free Demo Classes on Every Saturday and Sunday at 9:30 Am onward
Loading Events

« All Events


May 23, 2018 - May 23, 2022


Top Informatica Training @Spoorthy

Informatica is a Powerful ETL tool from informatica corporation, a leading provider of Enterprise Data integration Software and ETL Software,. The Important informatica components are: Power Exchange, Power Center,, Power Center Connect, Power channel, Metadata Exchange, Power Analyzer, and Super Glue,

In Informatica, All the metadata information about source systems, target systems and transformations are stored in the informatica repository.Informatica’s Power center client and Repository server Access this repository to store and retrieve metadata.



Our Courses prepared by Industry experts and Informatica Consultants
Lab Support
Our technical team is ready to assist you both online and inpremise
Our training covers best practices and real-time scenarios
Certification Assistance
We help you to prepare for certification exam



Neha Kour
Informatica Testing Specialist
Having 9+ years of experience in Informatica Technologies, Neha Kour worked in Accenture Company.


What do our Students say ?

Very good courses covering lots of topics. Excellent class delivery and lecture notes. I really learnt a lot and will surely miss not having the classes any more.
IT Consultant , T** Noida
Neraja Soumith

Very good learning experience. Training staff are really experienced. 24X7 Support is excellent,get response instantly. Great Spoorthy!!!
IT Consultant working in UK
Sravan Gupta

Awesome faculty. Awesome explanation on topics. I really appreciate Spoorthy Support team. They are really doing a fantastic job. Thanks once again.
Consultant, Hyderabad
Sai Kiran

Spoorthy is providing the best software training I have seen in my 10 years of IT career. I have been an Spoorthy student for over one year now. This is great way to learn.
Data Analyst, Pune
Ravi Kumar


Course Content

Introduction to Informatica


  • Basic Definitions
  • Informatica Products
  • Informatica Architecture
  • Tools and their roles
  • Folders -sub Folders
  • Power Center I Power Malt
  • Introduction to designer


Informatica Designer -Introduction


  • Designer interfaces
  • Designer tools
  • Defining Sources

       (i) Database as a source

       (ii) Rat Flies sources

  • Defining Targets
  • Importing from database
  • Creating a new target
  • Creating target database objects
  • Mapping Introduction


Informatica Designer 

  • Source Qualifier
  • Ports
  • Mapping -Table to Table
  • Mapping flat File to Table
  • Connected/Unconnected Transformations
  • Active and Passive Transformation
  • Source Qualifier Transformation
  • SQl Override-Source Qualifier Transformation


Mapping Source Qualifier as Filter


  • Source qualifier to join Data
  • Filter Transformation
  • Expression Transformation
  • Sequence Generator Transformation
  • Rank Transformation
  • Router Transformation
  • Aggregator Transformation
  • Joiner Transformation
  • Stored procedure Transformation (Connected & Unconnected)
  • Union Transformation
  • XMl Transformation
  • Mapping Wizards
  • Implementing Type-I, Type-II, Type-III
  • Mappings
  • Workflow Introduction


Informatica – workflow Manager Task


  • Workflow tools
  • Connections
  • Defining tasks

         (i) Command Task

         (ii) Email Task

          (iii) Session Task

          (iv) Link Conditions

(v) Event Wait & Event Raise

  • Setting Properties of Session Task
  • Creating Workflow
  • Starting Workflow
  • Monitoring Workflow
  • Incremental Aggregation

Informatica Advanced Features

  • Mapplet Implementation
  • Target Load Plan
  • Constraint based Loading
  • Mapping Parameters & Variables





May 23, 2018
May 23, 2022
Event Category:
Event Tags:


Spoorthy Software Solutions
+91 040-40208208


Spoorthy Software Solutions
#302,15/A, 16/A, 17/A, Nandhini Enclave, Addagutta Society, HMT Hill Road, Hyderabad, India
Hyderabad, Telangana 500090 India
+ Google Map
+91 040-40208208

Subscribe to our newsletter


Spoorthy Software Solutions believes in providing the quality training, consultation, staffing service to its clients.

With to impart new energy in the IT training by endowing first rate and industry oriented courses to churn out the next generation IT experts.

Upcoming Demos

  1. Microsoft Business Intelligence

    May 23, 2018 - May 23, 2022
  2. Informatica

    May 23, 2018 - May 23, 2022
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, how can I help?