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
How to reverse the string using SQL?
Can you define merge?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is difference between join, merge and lookup stage?
Define Data Stage?
Could anyone give brief explanation bout datastage admin
What are some different alternative commands associated with "dsjob"?
To see hidden files in LINIX?
What is the purpose of pivot stage?
Describe link sort?
How a routine is called in datastage job?
Can you explain link buffering?
how can we create rank using datastage?what is the meaning of rank?
What are the types of containers?
What is datastage?
