Informatica

From Infogalactic: the planetary knowledge core
Jump to: navigation, search

Lua error in package.lua at line 80: module 'strict' not found.

INFORMATÍCA
Private
Traded as Formerly NASDAQ: INFA
Industry Software industry
Headquarters Redwood City, California, United States
Area served
 Worldwide
Products Data Integration, Data Quality, Master Data Management, Information Lifecycle Management, Cloud
Revenue US$1.05 billion (2014)[1]
US$114 million (2014)
Number of employees
 5500+
Website http://www.informatica.com

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

History

The company was founded in 1993.

On April 29, 1999, it went public on NASDAQ Stock Exchange under the stock symbol INFA.

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.[5]

On August 6, 2015, Informatica announced completion of acquisition with Microsoft and Salesforce Ventures joined as strategic investors. The company's stock ceased trading on the NASDAQ under the ticker symbol INFA effective on the same date.[6][7][8] In December 2015, Gartner recognized Informatica in its December 2015 Magic Quadrant for Data Masking Technology report.[9]

Products

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. These components form a toolset for establishing and maintaining enterprise-wide data warehouses. It has a customer base of over 5,000 companies.[2][10]

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

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.[12] As of September 2014, it features over 1,300 pre-built mappings, templates, connectors and add-ons for Informatica data integration and cloud data integration products.[13]

Architecture

It is a service oriented Architecture and has the capability to share service and resource across several machines.[14] Informatica ETL product, known as Informatica Power Center consists of 3 main components.

  1. Informatica Power Center Client Tools: These are the development tools installed at developer end. These tools enable a developer to
    • Define transformation process, known as mapping. (Designer)
    • Define run-time properties for a mapping, known as sessions (Workflow Manager)
    • Monitor execution of sessions (Workflow Monitor)
    • Manage repository, useful for administrators (Repository Manager)
    • Report Metadata (Metadata Reporter)
  2. Informatica Power Center Repository: Repository is the backend of Informatica tools. Repository is a data inventory where all the data related to mappings, sources, targets etc. is kept. This is the place where all the metadata for an application is stored. All the client tools and Informatica Server fetch data from Repository.
  3. Informatica Power Center Server: In the Server, all the executions take place. Server makes physical connections to sources/ targets, fetches data, applies the transformations mentioned in the mapping and loads the data in the target system.


Types of transformations

  • 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 one 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 recognized by any of the following three factors:

  • the transformation changes the row type
  • the transformation changes the row order
  • transaction control happens in the transformation

A transformation which has these properties is said to be an "active transformation", otherwise it is said to be a "passive transformation".

Examples:

  • Source qualifier - converts source data types to Informatica data types; joins two source tables or files of the same type
  • Expression - transforms data with functions without affecting cardinality or data order
  • Lookups - enhances data elements with lookup values; may be connected or unconnected
  • Filter - filters incoming data
  • Router - routes data to selected output paths
  • Sorter - sorts data and optionally removes duplicate rows
  • Aggregator - aggregates data
  • Joiner - joins relational data midstream; can be used when source data is of multiple types
  • Normalizer - used with flat file input containing arrays or repeated data to create normal form relational data
  • Update Strategy - determines whether data is to be updated, inserted or deleted in cases where there are multiple output targets
  • Transaction Control - creates transactions and controls commits and rollbacks
  • Sequence Generator - generates a sequence of unique values as per the specified parameters
  • Java transformation - invokes Java methods, variables, third-party API's and built-in packages.

Financial results

File:Informatica HQ 1.JPG
Informatica headquarters in Redwood City
2014 2013 2012 2011 2010 2009
Revenue (USD) [15] 1,047,954,000 948,171,000 811,571,000 783,779,000 650,076,000 500,693,000
Net Income (USD) [16] 114,087,000 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.[10][17]

References

[14]

  1. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  2. ↑ 2.0 2.1 2.2 Lua error in package.lua at line 80: module 'strict' not found.
  3. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  4. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  5. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  6. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  7. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  8. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  9. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  10. ↑ 10.0 10.1 Lua error in package.lua at line 80: module 'strict' not found.
  11. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  12. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  13. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  14. ↑ 14.0 14.1 "Guide to Informatica Power Center"
  15. ↑ http://www.nasdaq.com/symbol/infa/revenue-eps
  16. ↑ http://www.wikinvest.com/stock/Informatica_(INFA)/Data/Net_Income
  17. ↑ Lua error in package.lua at line 80: module 'strict' not found.

External links

Retrieved from "https://infogalactic.com/w/index.php?title=Informatica&oldid=5542958"