Answer / prasad

i think there is no function on rank , you can write a sql
query for that one in oracle stage or drs stage/

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

4 Answers   Syntel,

---

Can you define merge?

0 Answers  

---

What is difference between server jobs & parallel jobs?

0 Answers  

---

Where do you see different stages in the designer?

0 Answers  

---

Explain the situation where you have applied SCD in your project?

0 Answers  

---

Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,

---

INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?

11 Answers   CTS,

---

whom do you report?

0 Answers   NTT Data,

---

How to perform incremental load in datastage?

0 Answers  

---

what are the errors,warnings in datastage

0 Answers   Syntel, Wipro,

---

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

4 Answers   ME,

---

What is the version control how can i apply this in DataStage can any one tell me the anser

4 Answers   IBM,

---