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

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 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.

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

Start a program step by step procedure in informatica

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:00PM 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.

Start a program step by step procedure in informatica

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

Step 3:-

Design a mapping with out 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

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

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 repository menu click on save

Step 5:-

Creation of workflow:-

A work flow is know as “start task” which can executed ne (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 work flow (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 indepth understanding of Informatica, click on

Summary
Review Date
Reviewed Item
Start a program step by step procedure in informatica
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 Start a program step by step procedure in informatica"

Leave a Message

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

Site Disclaimer, Copyright © 2016 - All Rights Reserved.