In this Informatica tutorial we will covers concepts of administrative skills and on the various developer Informatica PowerCenter concepts such as Designer, Workflow manage, 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 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.
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.
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 PowerCenter Online Training
Before going through these Informatica tutorial, we must about learn different Informatica PowerCenter components. Check the following.
- Informatica Administration console.
- Configure Domains nodes, Services.
- User Activity.
- Informatica Repository Manager.
- Informatica Design Manager.
- Configure Source.
- Configure Target.
- Configure Transformation.
- Informatica Workflow Manager.
- Work Let.
- Workflow Monitor.
- Workflows running status.