how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers  

---

input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?

2 Answers   HSBC,

---

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers   TCS,

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

0 Answers  

---

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,

---

How can we improve performance of data stage jobs?

0 Answers  

---

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,

---

What is the difference between Datastage 7.5 and 7.0?

0 Answers  

---

Define ds designer?

0 Answers  

---

in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

3 Answers   IBM, YCS,

---

I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers   CGI,

---

How can we do null handling in sequential files

3 Answers   Reliance,

---