Informatica is a software company that provides Data Integration products. According to running market, there is high demand for Informatica developers in Market and plenty of opportunities for career progression in Informatica. If your are a fresher or beginner and wanna make career in Informatica? Learn Informatica PowerCenter 10.0.1 for free? Access Informatica tutorials and download every Informatica tutorial that we explain in PDF format.

Informatica Tutorial – Learn Informatica PowerCenter

In this Informatica tutorial we  will covers concepts of administrative skills and on the various developer Informatica PowerCenter concepts such as Informatica PowerCenter Designer, Workflow manager, Workflow Monitor and Repository Manager. Learn Informatica PowerCenter now for free. Before going through these Informatica tutorial, we must about learn different Informatica components.

What is Informatica?

Informatica is an ETL tool or Integration tools, which is used to extract different Heterogeneous Sources like Sibel, Salesforce, Oracle Apps, PeopleSoft Mainframes etc, Transform as Analytical data (Aggregating data, cleaning data..) and Load into Data warehouse (DW).

Data Warehousing technologies have evolved as a result of the unsatisfied decisional information needs to enterprises. So what is a Data Warehouse ? According to Bill Inmon, a “Data Warehouse is a collection of integrated, subject-oriented databases designed to supply the information required for decision making. Each data item in the data warehouse is relevant to some moment in time“.

Informatica tutorial

Informatica Versions History

In Informatica the latest version is Informatica 10.1.1 and earlier famous versions of Informatica are 9.6, 9.5, 9.1, 9.0, 8.6, 8.1, 8.0, 7.1, 6.0, 5.0

  • Version 5.1 was released July 2001.
  • Version 6.0 was released September 2002.
  • Version 6.1 was released December 2002.
  • Version 6.2 was released April 2003.
  • PowerCenter 7.1(only) in Nov’ 2003.
  • Version 8.6 was released 2006.
  • Version 9.1 was released 2012.

Audience

This Informatica tutorial is designed for College graduates, IT professional working in other technologies  who wishes to make career in Data Warehousing or Informatica in simple and easy steps. These Informatica tutorials will throw a light on Informatica concepts like Installing and upgrading the components of Informatica PowerCenter tool, will covers concepts of administrative skills and on the various developer Informatica PowerCenter screens such as Designer, Workflow manage, Workflow Monitor and Repository Manager.

Prerequisites

Before proceeding with this Informatica tutorial, you should have the basic knowledge of Programming and Data Warehouse concepts like History of Data Warehouse, Data Warehouse Definition, What is data, Transactional Data, Analytical Data, Data Warehouse Architecture, Data Warehouse tools, What is OLTP and OLAP ? Schemas and SCDS, Data transformations like Data Merging, Data Cleaning,  Data Scrubbing and Data Aggregation.

What are the different Roles of Informatica?

In any Informatica project, we have mainly two roles they are

Developer : A Developer will create Mappings and Workflow’s by suing Designer and Workflow manager.

Administrator : Administrator is responsible to do all admin activities like creating users, groups, providing permissions and running the workflows.

Informatica tutorial – Online tutorials

Before going through these Informatica tutorial, we must about learn different Informatica PowerCenter components. Check the following.

Inforamatica Tutorial – Introduction basics.

Informatica Transformations.

  • All about Informatica Transformations.
  • Aggregator Transformation.
  • Filter Transformation.
  • Router Transformation.
  • Lookup Transformation.
  • Rank Transformation.
  • Expression Transformation.
  • Joiner Transformation.
  • Normalizer Transformation.
  • SQL Transformation.
  • Source Qualifier Transformation.
  • Sequence Transformation.
  • Sorter Transformation.
  • Transaction Control Transformation.
  • Union Transformation.
  • Update Strategy Transformation.
  • XML Generator Transformation.
  • XML Parser Transformation.