Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / hanug
To connect to any database we should check if we are able
connect to database from the server. We can configure by
specifying the database in the dsenv file.
Say ex: I am trying to configure to connect to ORacle. In
this case we should configure oracle in the dsenv. We also
need to check if we have the DB user present in the
tnsnames.ora
Once we have done the above steps, we can connect to Oracle
DB using Oracle connector or oracle Enterprise or DRS.
We need to specify Server, user name and DB password to
connect to DB.
By using Orachaestrate schema or Connector wizard, we can
import the DB objects.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between odbc and drs stage?
What are the functionalities of link partitioner and link collector?
What are transforms and what is the differenece between routines and transforms?
CHANGE CAPTURE
How and where you used hash file?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What are the different plug-ins stages used in your projects?
What are stage variables and constants?
What are the repository tables in datastage?
What are the types of views in datastage director?
What are some different alternative commands associated with "dsjob"?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Is the value of staging variable stored temporarily or permanently?
