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  

---

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

8 Answers   Semantic Space,

---

HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?

1 Answers   Infosys,

---

If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically

6 Answers   TCS,

---

Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,

---

---

HOW CAN WE SEE THE DATA IN DATASET?

12 Answers   IBM, TCS,

---

hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 Answers  

---

HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers   ME,

---

I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

4 Answers   CSC,

---

What are the steps needed to create a simple basic datastage job?

0 Answers  

---

In one project how many shared containers are created?

3 Answers   NTT Data,

---

What is difference between 8.1 , 8.5 and 9.1 ?

1 Answers   IBM,

---