Misplaced Pages

Informatica: Difference between revisions

Article snapshot taken from Wikipedia with creative commons attribution-sharealike license. Give it a read and then ask your questions in the chat. We can research this topic together.
Browse history interactively← Previous editNext edit →Content deleted Content addedVisualWikitext
Revision as of 10:14, 26 June 2016 edit101.63.146.169 (talk)No edit summary← Previous edit Revision as of 08:34, 22 July 2016 edit undo64.134.163.234 (talk)No edit summaryNext edit →
Line 17: Line 17:
}} }}


'''Informatica''' is a ] development company founded in 1993. It is headquartered in ].<ref name="company">{{citation | publisher=Informatica website | url=http://www.informatica.com/company/Pages/index.aspx | title=Informatica | first= | last= | date= | accessdate=15 May 2010}}</ref> It was founded by ] and Diaz Nesamoney.<ref>{{Cite web|title = Diaz Nesamoney {{!}} FT Press|url = http://www.ftpress.com/authors/bio/1a87f43b-da7d-4e32-b391-83f7751e7a3f|website = www.ftpress.com|accessdate = 2015-09-02}}</ref> ] is the company's CEO.<ref name="company" /> '''Informatica''' is a ] development company founded in 1993. It is headquartered in ].<ref name="company">{{citation | publisher=Informatica website | url=http://www.informatica.com/company/Pages/index.aspx | title=Informatica | first= | last= | date= | accessdate=15 May 2010}}</ref> It was founded by ] {{Cite web|title = Diaz Nesamoney {{!}} FT Press|url = http://www.ftpress.com/authors/bio/1a87f43b-da7d-4e32-b391-83f7751e7a3f|website = www.ftpress.com|accessdate = 2015-09-02}}</ref> ] is the company's CEO.<ref name="company" />


== History == == History ==

Revision as of 08:34, 22 July 2016

The article's lead section may need to be rewritten. Please help improve the lead and read the lead layout guide. (June 2011) (Learn how and when to remove this message)
INFORMATICA
Company typePrivate
Traded asFormerly Nasdaq: INFA
Industry Software industry
HeadquartersRedwood City, California, United States
Area servedWorldwide
ProductsData Integration, Data Quality, Master Data Management, Information Lifecycle Management, Cloud
RevenueUS$1.05 billion (2014)
Net incomeUS$114 million (2014)
Number of employees3,500+
Websitehttp://www.informatica.com

Informatica is a software development company founded in 1993. It is headquartered in Redwood City, California. It was founded by Sohaib Abbasi "Diaz Nesamoney | FT Press". www.ftpress.com. Retrieved 2 September 2015.</ref> Anil Chakravarthy is the company's CEO.

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.

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. In December 2015, Gartner recognized Informatica in its December 2015 Magic Quadrant for Data Masking Technology report.

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.

In 2006, Informatica launched its Informatica Cloud business.

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. 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.

Architecture

It is a service oriented Architecture and has the capability to share service and resource across several machines. 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

Informatica headquarters in Redwood City
2014 2013 2012 2011 2010 2009
Revenue (USD) 1,047,954,000 948,171,000 811,571,000 783,779,000 650,076,000 600,693,000
Net Income (USD) 114,087,000 86,400,000 93,180,000 117,500,000 86,320,000 54,210,000

Informatica has mainly seen growth through a combination of organic growth and growth through acquisition.

References

  1. Form 10-K (Annual Report), US SEC, retrieved 1 September 2015
  2. ^ Informatica, Informatica website, retrieved 15 May 2010
  3. "Informatica Announces Agreement to be Acquired by The Permira Funds and Canada Pension Plan Investment Board". permira.com. Retrieved 7 April 2015.
  4. "Informatica Corporation Announces Completion of Acquisition by the Permira Funds and Canada Pension Plan Investment Board". informatica.com. Retrieved 7 August 2015.
  5. "Salesforce Ventures and Microsoft Join Informatica Buyout". nytimes.com. Retrieved 7 August 2015.
  6. "Microsoft And Salesforce Join In $5.3 Billion Buyout Of Informatica". forbes.com. Retrieved 7 August 2015.
  7. "Gartner Positions Informatica as a Leader in 2015 Magic Quadrant for Data Masking Technology, Worldwide". GlobeNewswire. Retrieved 28 December 2015.
  8. ^ Magic Quadrant for Data Integration Tools, Gartner, 25 November 2009, retrieved 15 May 2010
  9. Adrian, Merv (10 June 2010), Informatica Re-Factors the Value Chain for the Cloud, IT Market Strategy, retrieved 7 July 2010
  10. "Informatica Marketplace-Press Release". Informatica. 9 February 2010.
  11. "Informatica Marketplace - Home". marketplace.informatica.com. Retrieved 17 September 2014.
  12. ^ "Guide to Informatica Power Center"
  13. http://www.nasdaq.com/symbol/infa/revenue-eps
  14. http://www.wikinvest.com/stock/Informatica_(INFA)/Data/Net_Income
  15. Karel, Rob (28 January 2010), Introducing The MDM Market's Newest 800lb Gorilla: Informatica Acquires Siperian!, Forrester, retrieved 15 May 2010

External links

Categories: