Informatica Components

Ratings:
(4.4)
Views:1238
Banner-Img
  • Share this blog:

Informatica Components Architecture

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 inserts, retrieves and updates metadata within the repository database tables. It strengthens the consistency within 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

If you want to enrich your career and become a professional in Informatica, then visit Tekslate - a global online training platform: "Informatica Training" This course will help you to achieve excellence in this domain.

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 supposes to process a high volume of data

It supports 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 a 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 designed 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.

Transformation logic

It defines data transformation

Extra:-

A mapping is nothing but an ETL plan processing

Mapping design with source definition, target definition, and business logic

Odbc (Open data base connectivity)

An odbc is a middleware (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 gets to 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 manager

Power Center Designer

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

The designer allows you to create the following power center objects.

Source definition

Target definition

Design mapping with or without transformation Rule or logic

Power Center Workflow Manager

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

Create a session for each mapping

Create a workflow 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 a pointer to map

Workflow

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

Workflow can execute only no. ________ in sequentially

 

The top objects in the power center development hierarchy are 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 workflow

Step 6:- Start Workflow.

Power Center Repository Managers

It is a GUI-based administrative client that 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 database which contains meta data which is required to perform extraction, transformation, and loading

The repository database consists of following the type of meta data objects.

Source definition

Target definition

Transformation rules

Mappings

Session

Odbc connection

Workflows

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

Introduction to Informatica

Local Repository

The metadata can be shared with in the repository

Informatica Tutorials For Beginners

Global Repository

Informatica Tutorials For Beginners

 

Repository Service

Repository service is a “multi-threaded” process that inserts, updates, delete and retrieves metadata from the repository.

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

The integration service accesses the repository through the 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 the repository service

The session log is 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 the repository.

It extracts the data from mapping sources, stored in a temporary memory called staging where it applies 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

Workflow manager Create and start workflows

Workflow monitor and controls workflows

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

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

The integration service is created with three components.

Reader

It extracts 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:00 PM;

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:00 PM – target –oracle

TNS service Name: ORCL

Userid : Batch 4:00 PM

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 stored in the repository.

For in-depth understanding of Informatica click on

About Author
Authorlogo
Name
TekSlate
Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.