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
sed,awk,head
What are the types of jobs we have in datastage?
Describe routines in datastage? Enlist various types of routines.
Explain usage analysis in datastage?
What are the types of hashed files in data stage
Name the third party tools that can be used in datastage?
How to RD using transformer?
What is ibm datastage flow designer?
How do you schedule or monitoring the job?
How to clean the datastage repository?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
If you want to use the same piece of code in different jobs, how will you achieve it?
Can you explain link buffering?
Define project in datastage?
Define Routines and their types?
