Answer / 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.

Answer / loga

Hi,


Am using DS 8.5 and Oracle 11g.
I want to connect Oracle with Data stage with 'oracle connector' stage. I am getting error message connection failed. Can any one tel me how to connect these.... Am new Data stage, its highly appreciated if you given answer with snapshots. Regards, Loga

What is a quality stage?

1 Answers  

---

What are the stages in datastage?

0 Answers  

---

Difference between the Sequence and Sequencer in DS?

1 Answers   TCS,

---

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---

What is RCP

5 Answers   CGI, CTS,

---

What are the processing stages?

0 Answers  

---

source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers   IBM,

---

How do you load 10 different sources with 10 different layouts to 10 different tables?

1 Answers   TIAA CREF,

---

what are the types of nodes

4 Answers   HCL, TCS,

---

what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,

---

how to sort two columns in single job in datastage.

1 Answers   TCS,

---