• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Informatica Components

Informatica Components Architecture

informatica tutorials

Server Components:

-Repository Service

-Integration Service

Repository Server:

-The Repository Server manages the metadata in the repository database.

-The Repository Server manages connections to the repository from client applications.

-The Repository Service is a separate, multi-threaded process that retrieves, inserts, and updates metadata in the repository database tables. The Repository Service ensures the consistency of metadata in the repository.

Integration Service:

The Integration Server reads mapping and session information from the repository. It extracts data from the mapping sources and stores the data in memory while it applies the transformation rules that you configure in the mapping. The Integration Server loads the transformed data into the mapping targets.

Client Components:

Repository Manager

Designer

Workflow Manager

Workflow Monitor

Informatica Components Overview

The following of the various business components which are placing a key role in developing data warehouse.

Informatics power center

Informatica power connect

Informatica power mart

Informatica power exchange

Informatica power analyses

Informatica power quality

Differences between Power Center and Power Mart

 Informatica Power Center

It suppose to process high volume of data

It support ERP source such as SAP, PeopleSoft etc…

It supports both global and local repositories

It can convert a local repository into global repository

Informatica Power Mart

It is recommended to process low volumes of data

It doesn’t support ERP sources such as SAP, people soft etc

It supports local repository

There is no specialty to convert local to global repository

Note:- An informatica power center is a gui based ETL product from informatica corporation.

Mapping Components

A mapping logically defines extraction transformation and loading

A mapping is design with the following components

Source definition

It is the structure of the source table (or) file from which data will be extracted.

Target definition

It is the structure of the target tables into which data loads.

Tranformation logic

It defines data transformation

Informatica Tutorials For Beginners

Extra:-

A mapping is nothing but a ETL plan processing

Mapping design with source definition, target definition and business logic

Odbc (Open data base connectivity)

An  odbc is a middle ware (or) an interface which allows you to access databases

Informatica Power Center 8.6 – components

When we install informatica power center 8.6 the following component get install.

Power center clients

Power center repository

Power center domain

Integration service

Repository service

Web service hub

Power center administration console

Power Center Clients

The following are the power center clients are

Power center designer

Power center workflow manager

Power center work flow monitor

Power center repository manger

Power Center Designer

The designer is GUI based client component which allows you to design a plane of ETL process known as mapping.

The designer allows you to create following power center objects.

Source definition

Target definition

Design mapping with or without transformation Rule or logic

Informatica Tutorials For Beginners

Power Center Workflow Manager

It is a  GUI based client component which allows you to create following power center objects.

Create a session for each mapping

Create work flow to start sessions

Session:-

A session is a power center object which runs mapping.

A session which makes mapping avail i.e. for extraction, transformation and loading

A session is the pointer to map

Workflow

A workflow is known as “St task” which can run one or more sessions. The sessions can sequential (or) parallels.

Informatica Tutorials For Beginners

Workflow can execute only no. ________ in sequentially

Informatica Tutorials For Beginners

Informatica Tutorials For Beginners

The top objects in the power center development hierarchy is workflow.

Power Center Workflow Monitor

It is a GUI based client component which allows you to monitor the session and workflow running on integration service.

It allows you to view session and work flow and session states

It allows you to fetch the session log from repository

Integration services is an ETL engine it perform ETL

Informatica Tutorials For Beginners

Steps involving implementing ETL Process:-

Step 1. :- Creation of source definition

Step 2 :- Creation of target definition

Step 3:- design a mapping with (or) without transformation rule  Workflow manager

Step 4:- Create a session for each mapping

Step 5:- Create work flow

Step 6:- Start Work flow.

Power Center Repository Managers

It is a GUI based administrative client which allows you to perform the following tasks.

Create, edit, delete folders

Assign, permission and permilizer to the users or user groups

Informatica Tutorials For Beginners

Power Center Repository

The  power center repository is a relational database, a system databases which contains meta data which is required to perform extraction, transformation and loading

The repository database consist of following type of meta data objects.

Source definition

Target definition

Transformation rules

Mappings

Session

Odbc connection

Work flows

Session logs

The Repository is the brain of ETL system which contains “instructions” required to perform ETL. There are two types of repository can be created.

Local repository

Global repository

Local Repository

The metadata an be shared with in the repositor

Informatica Tutorials For Beginners

Global Repository

Informatica Tutorials For Beginners

Repository Service

The Repository service is a “multithreaded” process which inserts, updates, delete and retrieve metadata from repository.

The power center client applications access the repository through repository service.

The integration service access the repository through repository service to read the metadata such as mapping and sessions.

The integration service also stores metadata such as session log, session and workflow status in the repository through repository service

Session log are created integration service.

Informatica Tutorials For Beginners

Integration Service

The Integration service is an ETL engine which performs extraction transformation and loading

The integration service reads session and mappings from repository.

It extract the data from mapping sources, stores in a temporary memory called staging where it apply the transformation rules to process the data.

It loads transformed data into mapping targets

Success and  failures and session logs are created integration service

Integration service ETL Process engine

Repository collection of tables that contains power center metadata

Repository services A centralized management of repository connection

Repository manager Performs repository security

Designer Create mapping objects

Work flow manger Create and start work flows

Work flow monitor and controls work flows

Repository services process Multi threaded process that retrieves, update, inserts, repository metadata.

These core tutorials will help you to learn the fundamentals of Informatica. For an in-depth understanding and practical experience,  explore Informatica Training Online.

Power Center Architecture:- Components

Sources:- It defines  the extraction, it can be relational tables, flat files, XML files, cobal files, SAP, Oracle application etc.

Targets

It defines the data loading, it can be relational tables (or) files.

Integration services:-

The engine that performs extraction, transformation and loading.

Repository Service

It manager connected  to the metadata repository that contains mappings session and workflow definition.

Repository Services Process

A multi-threaded process that retrieves, inserts and updates repository metadata.

Repository:-

It contains all of the metadata need to run ETL proc

Client Tools

Desktop tools used to populate the repository with metadata execute workflows and integrating service and monitory service and manage the repository.

Populate metadata means extraction transformation and loading mapping source workflow

Integration Service – Component

An Integration service is created with three components.

Reader

It extract  the data from various types of sources the following are the types of readers

Relational reader

File reader

XML Reader

DTM (Data transformation manager)

It transforms the data according to the business logic that you configure in the mapping.

Writer

It inserts the data into a target system.

The following are the types of writers

Relational writer

File writer

XML writer

Setup Source and Target Database

Informatica Tutorials For Beginners

Start Programs oracle  Application development

Client on SQL Plus.

Enter the following Logon details

Username : System

Password : NiPUNA

Host string : ORCL

SQL > Create user batch 4:00 PM identified by target:

User created

SQL> Grant DBA to Batch 4:00PM;

SQL> Connect batch4:00PM / Target@ORCL;

Connected

SQL> Show user

Create table dim- employee (EMPNO Number(5),

Ename Varchar2(15)

Sal Number (7,2),

Deptno Number (5));

Table created

SQL> conn scott

Enter Password: *****

Creation of dob connections

Source odbc:- Procedures

Start settings control panel Administrative tools Datasources (odbc)

Select system DSN tab click on add

Select the driver oracle in ORADDBLOG-home click on finish

Enter the following details

Data source name: Batch 4:00 PM _ source_oracle

TNS Service Name : ORCL

User ID : SCOTT

Click on Test connection

Enter password: Tiger click ok

Target odbc:- procedure:

From system DSN Tab click on Add

Select the driver oracle in oraDblog-home1

Click on finish.

Data source name : Batch 4:00PM – target –oracle

TNS service Name :ORCL

Userid : Batch 4:00PM

Click on test connection

Enter password: Target click ok

Informatica Services

Start settings control panel administrative tools services

Start the following services

Informatica orchestration service

Informatica services 8.6.0

Creation of folder

A folder  is a power center object which allows you to organize the metadata store in the repository.

For indepth understanding of Informatica click on

Summary
Review Date
Reviewed Item
Informatica Components
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Informatica Components"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.