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.

What are the benefits of datastage?

1234

---

Describe the architecture of datastage?

1001

---

What are the different layers in the information server architecture?

1122

---

How rejected rows are managed in datastage?

1508

---

What is the difference between odbc and drs stage?

1087

---

Define meta stage?

1200

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1541

---

Differentiate between validated and Compiled in the Datastage?

1268

---

What are the various kinds of containers available in datastage?

1044

---

Explain datastage architecture?

1394

---

What are the functionalities of link partitioner and link collector?

1005

---

Triggers,VIEW,Procedures

1215

---

How a routine is called in datastage job?

1093

---

What is meta stage?

1174

---

What is the project in datastage?

1106

---