From Wikipedia, the free encyclopedia
Jump to: navigation, search
Industry Software industry
Headquarters Redwood City, California, United States
Area served
Products Data Integration, Data Quality, Master Data Management, Information Lifecycle Management, Cloud
Revenue $948 million(2013) [1]
Number of employees

Informatica Corporation is a software development company founded in 1993. It is headquartered in Redwood City, California.[2] It was founded by Diaz Nesamoney and Gaurav Dhillon. Sohaib Abbasi is the company's chairman and CEO.[2]


Informatica's product is a portfolio focused on Data Integration: ETL, Information Lifecycle Management, B2B Data Exchange, Cloud Data Integration, Complex Event Processing, Data Masking, Data Quality, Data Replication, Data Virtualization, Master Data Management, Ultra Messaging; currently at version 9.6 [2] These components form a toolset for establishing and maintaining enterprise-wide data warehouses. It has a customer base of over 5,000 companies.[2][3]

In 2006, Informatica launched its Informatica Cloud business.[4]

In 2010, the Informatica Marketplace was launched offering a data integration eco-system for Partners, Customers, Developers and Informatica to share and leverage data integration solutions.[5] As of Sept 2014, it features over 1,300 pre-built mappings, templates, connectors and add-ons for Informatica data integration and cloud data integration products.[6]

On April 7, 2015, Permira and Canada Pension Plan Investment Board announced that a company controlled by the Permira funds and CPPIB has signed a definitive agreement to acquire Informatica for approximately US$5.3 billion.[7]


Informatica PowerCenter, It is a client-server Architecture .

Types of transformations[edit]

  • Active : One that can change the number of rows being output.
  • Passive : One that cannot change the number of rows being output.
  • Connected : One that has at least 1 link with other transformations or objects in a mapping
  • Unconnected : One that does not have any link with any transformations or objects in a mapping

Also, Active transformation are recognised by the following three factors

  • If a transformation changes the row type,
  • If a transformation changes the row order,
  • If Transaction control happens in the transformation.

Then the transformation is ᾈ to be active transformation, and on the other hand those transformation doesn't do these three things basically are said to be passive transformation. Transformations example •Source qualifier - conversion of source datatypes to Informatica datatypes

  • Expression - transforming data with functions
  • Lookups - joining data with lookups
  • Filter & Router - This Transformations are used to filter the incoming data based on the condition provided .
  • Sorter & Aggregator - sorting and aggregating data
  • Update Strategy expressions - used to update the data based on the condition.
  • Transaction control - how to create transactions and control commits and rollbacks
  • Sequence Generator - for generation of a sequence or unique values as per the specified parameters
  • Java transformation - invoking Java methods, variables, third-party API's and built-in packages with Java transformation
  • Router transformation-Router Transformation Router Transformation in Informatica, is a connected and active transformation which let you to transfer row to multiple target depending upon the different condition. A Filter transformation rejects the row which don’t satisfy its condition whereas Router allow you to pass the failed data to some default target as well.In below article we will go through the properties of Router Transformation. We will also discuss the steps of adding /configuring Router transformation in Informatica Mapping.

Financial results[edit]

Informatica headquarters in Redwood City
2013 2012 2011 2010 2009
Revenue (USD) [8] 948,171,000 811,571,000 783,779,000 650,076,000 500,693,000
Net Income (USD) [9] 86,400,000 93,180,000 117,500,000 86,320,000 64,210,000

Informatica has mainly seen growth through a combination of organic growth and growth through acquisition.[3][10]


  1. ^ Seeking Alpha, Seeking Alpha, retrieved 23 Jan 2014 
  2. ^ a b c d Informatica, Informatica website, retrieved 15 May 2010 
  3. ^ a b Magic Quadrant for Data Integration Tools, Gartner, 25 November 2009, retrieved 15 May 2010 
  4. ^ Adrian, Merv (10 June 2010), Informatica Re-Factors the Value Chain for the Cloud, IT Market Strategy, retrieved 7 July 2010 
  5. ^ "Informatica Marketplace-Press Release". Informatica. Feb 9, 2010. 
  6. ^ "Informatica Marketplace - Home". Retrieved Sep 17, 2014. 
  7. ^ "Informatica Announces Agreement to be Acquired by The Permira Funds and Canada Pension Plan Investment Board". Retrieved Apr 7, 2015. 
  8. ^
  9. ^
  10. ^ Karel, Rob (28 January 2010), Introducing The MDM Market’s Newest 800lb Gorilla: Informatica Acquires Siperian!, Forrester, retrieved 15 May 2010 

External links[edit]