Describe the main features of datastage?

0 Answers  

---

I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

6 Answers  

---

deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers   IBM, TCS,

---

how to validate the jobs

2 Answers   IBM,

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,

---

---

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

5 Answers   Cap Gemini,

---

HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

1 Answers   IBM,

---

What is the function in Transformer stage can act as Rank Function in oracle

1 Answers   Reliance,

---

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,

---

Difference between the Sequence and Sequencer in DS?

1 Answers   TCS,

---

what r the stages mostly used in realtime scenarios

4 Answers   HCL, IBM,

---

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

---