Answer / farzana kalluri

seq file--->sort(descending)stage--->surrogate key stage---
>target


sort tha data in descending order ,then it will shows from
highiest salary, after that keep surrogate key stage it
will automtaically generates the nos so that we can
identifiy the 2nd hieght salary .

Answer / subhash

for 2nd Qn:
Source is:
Col1 Col2
1 10
2 10
3 10
In transformer, we put the below logic:

Link.Col1 * Link.Col2 + Link.Col2------>Col2

1*10+10------------->20
2*10+10------------->30
3*10+10------------->40

Hope this is fine.

Answer / ram

there are two ways you can get.
1. sort the data in descending order and make true the
create key change column.
2. this can be done in transformer stage at stage variables.
a. first sort the data on descending order (key would the
column which you wanted to be).
define three stage variables in transformer....sv1,sv2 & sv3
set sv2 and sv3 initial values to 0.
then...
if (salary=sv3) then sv2 else (sv2+1) ------> sv1
sv1 -------> sv2
salary --------> sv3

in next link filter...
constraint sv1=1
now you can see all 1st highest salary, 2nd highest
salary..and so on

What are the types of containers in datastage?

0 Answers  

---

What is the process of killing a job in datastage?

0 Answers  

---

With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,

---

Nls stands for what in datastage?

0 Answers  

---

What is mapping?

3 Answers  

---

I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,

---

I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().

1 Answers   Amdocs, TCS,

---

How to delete the data in dataset?types of deleting the data in dataset?

4 Answers   HSBC,

---

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,

---

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,

---

Where do the datastage jobs get stored?

0 Answers  

---

Why fact table is in normal form?

0 Answers  

---