Answer / nish

answer:

there is no function equivalent to that.

Rank is mostly used as an analytic/aggregating function in oracle and takes 2 columns for arguments.

Transformer stage performs transforming operations for later analysis ,doesnt directly perform analytic functions.

The closest stage would be an sort- aggregator stage for RANK.

Please remember that not all interview questions have a definitive answer.
This one tests confidence of how much you really used transformer stage.

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,

---

What is active and passive stage?

0 Answers  

---

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,

---

In Datastage, how you can fix the truncated data error?

0 Answers  

---

hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

1 Answers   Polaris,

---

---

how can we extract data with out having any common column

7 Answers   IBM, Switch2iTech,

---

how to export or import the jobs in .ISX file

0 Answers  

---

What is the command line function to import and export the ds jobs?

0 Answers  

---

How a routine is called in datastage job?

0 Answers  

---

can we see the data in fixed width file? how can u change the datatype of fixed width files?

1 Answers   Infosys,

---

What is the difference between server job and parallel jobs?

0 Answers  

---

What is mapping?

3 Answers  

---