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
What is the difference between an operational datastage and a data warehouse?
Explain connectivity between datastage with datasources?
What is the method of removing duplicates, without the remove duplicate stage?
Why do we use exception activity in Datastage?
How to perform incremental load in datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
What are the functionalities of link collector?
CHANGE CAPTURE
What is a ds designer?
what are the errors,warnings in datastage
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is usage analysis in datastage?
Define repository tables in datastage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
