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 do you remove duplicate values in datastage?
What are the different options associated with dsjob command?
What is the differentiate between data file and descriptor file?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the repository tables in datastage?
What is meta stage?
Where the datastage stored his repository?
Differentiate between Join, Merge and Lookup stage?
How do u convert the columns to rows in datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
In Datastage, how you can fix the truncated data error?
What is datastage engine?
Describe the architecture of datastage?
Explain connectivity between datastage with datasources?
How many types of hash files are there?
