Introduction to Informatica

Informatica Corporation is a software company founded in 1993 by Gaurav Dhillon and Diaz Nesamoney. Informatica Corporation is well known for its data integration (ETL) product PowerCenter. A lot of times when people say Informatica they actually mean Informatica PowerCenter!

Over the course of last 10 years Informatica has introduced a series of products – all related to Data Integration & Warehousing. A quick list of Informatica products is right here:

  • PowerCenter
  • B2B Data Exchange
  • MDM – Master Data Management
  • TDM/ILM – Test Data Management / Information Lifecycle Management / Data Archive
  • Informatica Data Masking / Dynamic Data Masking
  • iPaaS – Integration Platform as a Service
  • Informatica Data Virtualization

Now that you have an idea about the company and products lets talk about PowerCenter.

Informatica PowerCenter is a tool, supporting all the steps of Extraction, Transformation and Load process. A whole lot of product offerings are orchestrated around PowerCenter’s ability to connect to different technologies ranging from mainframe to CRM to Big Data.

Informatica PowerCenter is an easy to use tool. It has got a simple visual interface like forms in visual basic. You just need to drag and drop different objects (known as transformations) and design process flow for data extraction transformation and load. These process flow diagrams are known as mappings. Once a mapping is developed, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases.

PowerCenter can communicate with all major data sources (mainframe, Big Data, RDBMS, Flat Files, XML, SAP, Salesforce & the list goes on), can move/transform data between them. It can move huge volumes of data in a very effective way, many a times better than even bespoke programs written for specific data movement. It can throttle the transactions (do big updates in small chunks to avoid long locking and filling the transactional log). It can effectively join data from two distinct data sources (even a xml file can be joined with a relational table). In all, Informatica has got the ability to effectively integrate heterogeneous data sources & converting raw data into useful information.

Some facts and figures about Informatica Corporation:

  • Founded in 1993, based in Redwood City, California
  • 5500 + Employees; 5000 + Customers
  • NASDAQ Stock Symbol: INFAStock Price: $48.73 (11/06/2015)
  • Revenues in fiscal year 2014: $1.05 Billion

In short, Informatica is worlds leading ETL tool & its rapidly acquiring market as an Enterprise Integration Platform.

8 Responses to Introduction to Informatica

  1. Hi .. i am new to this informatica tool. what are the function?
    why informatica?
    i want to learn work flow of this.. and i need to know how to involve this tool to my project.. could you please tell me what i ask?

  2. Great explanation sir, keep up the good work 🙂

  3. Hi Team,
    Can you please let me know about Informatica IDQ and MDM concepts. Also suggest some site to do the self learning?

  4. Hi Suba. Extraction Transform and Load (ETL) is a data integration technology that extracts data from several heterogeneous data sources, combines and standardizes the data, then presents or stores the data in a uniform format for informational purposes. ETL is necessary because many non-modern system architectures evolved over the years in environments where data was typically captured, processed and stored by separate and distinct software applications and databases.

  5. Hi,
    Nice article and thanks for sharing. Can you explain about What is the scope of Informatica ETL tool?

  6. Hola,

    Gasping at your brilliance! Thanks a tonne for sharing all that content. Can’t stop reading. Honestly!

    Could you please explain with a small example? I don’t know this CONNECT BY ROOT clause.

    In general there are ways to implement recursion in PowerCenter, though – depending on your setup – these may become a little tricky. You can find, for example, a Velocity article about Best Practice SQL

    Override where the last use case covers resolving recursive data structures.
    Be warned that this article is LONG (20 pages) and this one use case alone takes 10 pages for all the necessary explanations.

    It was cool to see your article pop up in my google search for the process yesterday. Great Guide.
    Keep up the good work!

    Irene Hynes

Leave a Reply