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
What are the different types of lookups in datastage?
Define APT_CONFIG in Datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
How many Key we can define in remove duplicate stage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
how to add a new records into source?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
how do u catch bad rows from OCI stage? And what CLI stands for?
What is the use of datastage director?
Can you explain tagbatch restructure operator?
What is the difference between informatica and datastage?
which r the connectors used in san?
Explain connectivity between datastage with datasources?
What a datastage macro?
What is the purpose of pivot stage and types of containers in datastage
