Start a program step by step procedure in Informatica

 

Start a program step by step procedure in Informatica

Creation of dob connections;

Source odbc:- Procedures:-

Start settings control panel Administrative tools Data sources (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: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 store in the repository.

 

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.

 

Navigation:-

Start Programs Informatica power center 8.6.0 client PowerCenter repository manager.

• From repository, navigator window select the repository Nivna-Rep right-click on connect.

Connect to the repository  with the following details

Username : Administrator

Password : Administrator

Click on connect

• From folder menu select create

Enter the folder name (Batch 4:00 PM) Click ok

Step 1:-

Creation of source definition:-

A source definition can be created using source analyzer tool in the design client comport.

Procedure:-

Start program Informatica power center 8.6.0  client power center designer.

Procedure:-

• From repository, navigator window select the repository

Niiuna-Rep Right click on connect

Username : Administrator

Password : Administrator

Click on Connect

• Select the folder batch 4:00 PM from Tools menu select source analyzer
• From source menu select import from database

Connect the database with the following details

Odbc data source : Batch 4:00PM – Source – Oracle

User Name : Scott

Owner Name : Scott

Password : Tiger

Click on connect

Select the table (EMP) click OK

• From Repository menu click on save

Step 2:-

Creation of target definition:-

A target definition can be created using target design tool in the designer-client component.

Procedure:-

• From tool menu, select target designer from target menu click on import from database

Connect to the database with the following details

Odbc Datasources: Batch 4:00PM – target – Oracle

Username: Batch 4:00 pm

Owner name : Batch 4:00PM

Password : Target

Click on connect

Select the table (dim-employee) click ok

From Repository menu click on save

Informatica Interview Questions & Answers

Step 3:-

Design a mapping without a transformation Rule:-

A mapping is made up of

• Source definition
• Target definition
• Transformation rule

Every mapping is univcly identified by mapping name.

The source table definition by default associate with “source qualifier” which defines data extraction.

Procedure:-

From Tools menu, select mapping designer

From mappings menu select create

Enter the mapping name (m-simple pass) click ok

• From source sub folder drop the source definition (emp) to the mapping designer work space
• From the Target subfolder drop the target definition (dim-employee) to the mapping designer work space.
• From source qualifier(SQ-emp) the columns with the corresponding columns in the target with simple drag and drop operation.
• From Repository menu click on save

Step 4:-

Creation of Session:-

• Open the client power center workflow manager
• Connect to the repository with valid username and password

Select the folder Batch 4:00pm

• From tools menu select task developer
• From task menu select create
• Select the task types session
• Enter the name : S.M-Simple pass

Click on create

Select the mapping (M- simple pass)

Click ok

• From the repository menu click on save

Creation of relational reader connection:-

From connection menu select relational select the type oracle

Click on New

Enter the following details

Name: batch 4:00PM _Src_reder

User Name : Scott

Password : Tiger

Connect String : ORCL

Click ok

Creation of relational writer connection:-

Click on New

Enter the following details

Name : Batch 4:00PM – TRG- Writer

Username : Batch 4:00PM

Password : Target

Connect String : ORCL

Click OK

• Double click the session select the mapping tab from left Paine select SQ-EMP
• From connections click on Relational connection browser
• Select batch 4:00PM –src – Reader
• From left pain select target dim-employee

From connection click on relational connection browser

Select batch 4:00 PM-TRG-Writer

Click OK

• From properties select target load type of normal click apply and ok
• From the repository menu click on save

Introduction to Informatica

Step 5:-

Creation of workflow:-

A workflow is known as “start task” which can execute one (or) more session.

Procedure:-

• From tools, menu select workflow designer

From workflow, menu select create

Enter the workflow name : W-S-m-simple pass

Click ok

• From session, subfolder drop the session beside the workflow (start task)

From task menu select link task

Drag link from workflow drop on session from repository, menu click on sare.

Note:- CREATE table BSR as select * from scott. EMP where 1=2;

It is used to create a table named BSR with same data definition of emp table in the scott account.

Step 6:-

Start work flow:-

Procedure:-

From workflow menu click on start workflow.

For in-depth understanding of Informatica, click on

• Rank Transformation in Informatica
• Aggregator Transformation in Informatica
• Expression Transformation in Informatica
• Lookup Transformation in Informatica
• ETL Project Architecture
• Interview Questions