to be rewritten . please discuss this issue on the article s talk page . use the lead layout guide to ensure the section follows wikipedia s norms and to be inclusive of all essential details . june 2011 learn how and when to remove this template message informatica type 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 net income us 114 million 2014 number of employees 3 500 website http www.informatica.com informatica is a software development company founded in 1993 . it is headquartered in redwood city california . 2 it was co founded by gaurav dhillon and diaz nesamoney . anil chakravarthy is the company s ceo . 2 contents 1 history 2 products 3 architecture 3.1 types of transformations 4 financial results 5 references 6 external links history edit 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 . 3 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 . 4 5 6 in december 2015 gartner recognized informatica in its december 2015 magic quadrant for data masking technology report . 7 products edit 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 8 in 2006 informatica launched its informatica cloud business . 9 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 . 10 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 . 11 architecture edit informatica uses a service oriented architecture and has the capability to share services and resources across several machines . 12 informatica etl product known as informatica powercenter consists of 3 main components which are as follows informatica powercenter client tools these are the development tools installed at the developer end . these tools enable a developer to define transformation processes known as mappings designer define run time properties for a mapping known as sessions workflow manager monitor execution of sessions workflow monitor manage a repository which is useful for administrators repository manager report metadata metadata reporter informatica powercenter 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 . informatica powercenter 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 edit active one that can change the number of rows being output passive one that can not 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 edit informatica headquarters in redwood city 2014 2013 2012 2011 2010 2009 revenue usd 13 1 047 954 000 948 171 000 811 571 000 783 779 000 650 076 000 600 693 000 net income usd 14 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 . 8 15 references edit 12 form 10 k annual report us sec retrieved 1 sep 2015 a b c informatica informatica website retrieved 15 may 2010 informatica announces agreement to be acquired by the permira funds and canada pension plan investment board . permira.com . retrieved apr 7 2015 . informatica corporation announces completion of acquisition by the permira funds and canada pension plan investment board . informatica.com . retrieved aug 7 2015 . salesforce ventures and microsoft join informatica buyout . nytimes.com . retrieved aug 7 2015 . microsoft and salesforce join in 5.3 billion buyout of informatica . forbes.com . retrieved aug 7 2015 . gartner positions informatica as a leader in 2015 magic quadrant for data masking technology worldwide . globenewswire . retrieved 28 december 2015 . a b magic quadrant for data integration tools gartner 25 november 2009 retrieved 15 may 2010 adrian merv 10 june 2010 informatica re factors the value chain for the cloud it market strategy retrieved 7 july 2010 informatica marketplace press release . informatica . feb 9 2010 . informatica marketplace home . marketplace.informatica.com . retrieved sep 17 2014 . a b informatica tutorial http www.nasdaq.com symbol infa revenue eps http www.wikinvest.com stock informatica infa data net income karel rob 28 january 2010 introducing the mdm market s newest 800lb gorilla informatica acquires siperian forrester retrieved 15 may 2010 external links edit wikimedia commons has media related to informatica corporation . official website informatica cloud website informatica marketplace website retrieved from https en.wikipedia.org w index.php title informatica & oldid 744367741 categories companies formerly listed on nasdaqextract transform load toolsdevelopment software companiesdata warehousing productscomputer companies of the united statescloud computing providerscompanies based in redwood city californiahidden categories wikipedia introduction cleanup from june 2011all pages needing cleanuparticles covered by wikiproject wikify from june 2011all articles covered by wikiproject wikifycommons category with local link same as on wikidatause dmy dates from march 2011 navigation menu personal tools not logged intalkcontributionscreate accountlog in namespaces article talk variants views read edit view history more search navigation main pagecontentsfeatured contentcurrent eventsrandom articledonate to wikipediawikipedia store interaction helpabout wikipediacommunity portalrecent changescontact page tools what links hererelated changesupload filespecial pagespermanent linkpage informationwikidata itemcite this page print export create a bookdownload as pdfprintable version in other projects wikimedia commons languages deutschfran aisitalianolatvie u edit links this page was last modified on 14 october 2016 at 19 25 . text is available under the creative commons attribution sharealike license ; additional terms may apply . by using this site you agree to the terms of use and privacy policy . wikipedia is a registered trademark of the wikimedia foundation inc. a non profit organization . privacy policy about wikipedia disclaimers contact wikipedia developers cookie statement mobile view