create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid   salary   previoussalary 10      1000     null 20      2000     1000 30      3000     2000       40      4000     3000

5 Answers   Genpact,

---

Explain the situation where you have applied SCD in your project?

0 Answers  

---

Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,

---

Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.

3 Answers   Cognizant, UHG,

---

Name the command line functions to import and export the DS jobs?

0 Answers  

---

---

What is the purpose of pivot stage and types of containers in datastage

0 Answers  

---

What are the processing stages?

0 Answers  

---

how to define satge variables in transformer stage

2 Answers  

---

CHANGE CAPTURE

0 Answers   CTS,

---

Can you define merge?

0 Answers  

---

what is executable in DataStage?

2 Answers  

---

How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?

2 Answers   Wipro,

---