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

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,

---

Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?

4 Answers   Wipro,

---

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

1 Answers   IBM,

---

Wat is isolation level and when do u use them?

1 Answers   HP, IBM,

---

types of errors in datastage?

2 Answers   Reliance,

---

---

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers   Cognizant, HCL, TIAA CREF,

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

0 Answers   CTS,

---

What is a datastage job?

0 Answers  

---

what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,

---

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,

---

j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

1 Answers   Wipro,

---

How many types of views are there in a datastage director?

0 Answers  

---