how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

3 Answers   Accenture,

---

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,

---

what is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,

---

What is a folder? Difference types of stages?

0 Answers  

---

how many write modes are there in ds

2 Answers   IBM,

---

Pls tell me what is troubleshooting in datastage view?

1 Answers  

---

What are system variables and sequencers in datastage

0 Answers  

---

where the log files or tables can store in DS?

2 Answers   IBM,

---

Why do we use link partitioner and link collector in datastage?

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 the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,

---

what is materialized view used datastage?

1 Answers   HSBC,

---