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