Start settings control panel Administrative tools Data sources (odbc)
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
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.
Start settings control panel administrative tools services
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.
Start Programs Informatica power center 8.6.0 client PowerCenter repository manager.
Connect to the repository with the following details
Username : Administrator
Password : Administrator
Click on connect
Enter the folder name (Batch 4:00 PM) Click ok
A source definition can be created using source analyzer tool in the design client comport.
Start program Informatica power center 8.6.0 client power center designer.
Niiuna-Rep Right click on connect
Username : Administrator
Password : Administrator
Click on Connect
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
A target definition can be created using target design tool in the designer-client component.
Procedure:-
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:-
A mapping is made up of
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
Step 4:-
Select the folder Batch 4:00pm
Click on create
Select the mapping (M- simple pass)
Click ok
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
Click on New
Enter the following details
Name : Batch 4:00PM – TRG- Writer
Username : Batch 4:00PM
Password : Target
Connect String : ORCL
Click OK
From connection click on relational connection browser
Select batch 4:00 PM-TRG-Writer
Click OK
A workflow is known as “start task” which can execute one (or) more session.
Procedure:-
From workflow, menu select create
Enter the workflow name : W-S-m-simple pass
Click ok
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.
Procedure:-
From workflow menu click on start workflow.
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
1/6
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.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox