Scribd
Upload
25 views2 pages

Main Products: Type of Transformations

Informatica is a software company that provides a portfolio of data integration tools including ETL, data quality, data masking, data replication, data virtualization, master data management, and cloud data integration. Their flagship product, Informatica PowerCenter, uses transformations to transform data in multiple ways through functions like source qualifiers, lookups, sorting, and Java transformations. Informatica has over 5,000 customers and has seen increasing annual revenue from $500 million in 2009 to over $948 million in 2013.

Uploaded by

mike56sumakar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
25 views2 pages

Main Products: Type of Transformations

Informatica is a software company that provides a portfolio of data integration tools including ETL, data quality, data masking, data replication, data virtualization, master data management, and cloud data integration. Their flagship product, Informatica PowerCenter, uses transformations to transform data in multiple ways through functions like source qualifiers, lookups, sorting, and Java transformations. Informatica has over 5,000 customers and has seen increasing annual revenue from $500 million in 2009 to over $948 million in 2013.

Uploaded by

mike56sumakar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Main 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; currently at version 9.6
[3]
These
components form a toolset for establishing and maintaining enterprise-wide data warehouses. It has a
customer base of over 5,000 companies.
[3][4]

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

Working Architecture[edit]
Informatica PowerCenter, the flagship tool of Informatica works on basis of transformations which transform
data in multiple ways.
Type of transformations:
Active : One that can change the number of rows being output.
Passive : One that cannot change the number of rows being output.
Transformations examples:
Source qualifier - conversion of source datatypes to Informatica datatypes
Expression - transforming data with functions
Lookups - joining data with lookups
Sorter & Aggregator - sorting and aggregating data
Update Strategy expressions
Transaction control - how to create transactions and control commits and rollbacks
Java transformation - invoking Java methods, variables, third-party API's and built-in packages with Java
transformation
Financial results[edit]


Informatica headquarters in Redwood City

2013 2012 2011 2010 2009
Revenue (USD)
[6]
948,171,000 811,571,000 783,779,000 650,076,000 500,693,000
Net Income (USD)
[7]
86,400,000 93,180,000 117,500,000 86,320,000 64,210,000

You might also like