count number of deptno in a emp table?

2 Answers   IBM,

---

options available in sequence job to run,validate?

0 Answers   CTS,

---

What is container and then types?

1 Answers  

---

What is aggtorec restructure operator?

0 Answers  

---

Where the datastage stored his repository?

0 Answers  

---

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  

---

i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 Answers  

---

Tell me Wt main advantage of Stage varibles? Project level hints?

4 Answers   Hexaware,

---

Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?

7 Answers   IBM,

---

source contains 2 columns comes to target 4 columns how

1 Answers   IBM,

---

What is exact difference between Parallel Jobs and server Jobs..

8 Answers   DELL, IBM,

---

What is the purpose of pivot stage?

0 Answers  

---