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.

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,

---

why we use parameters instead of hard code in datastage

4 Answers   HCL,

---

how to add a new records into source?

0 Answers  

---

how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel

3 Answers   Wipro,

---

if ename='subbu' while running job the job should be abort how come?

3 Answers   IBM,

---

What is mapping?

3 Answers  

---

What can we do with datastage director?

0 Answers  

---

Can you explain tagbatch restructure operator?

0 Answers  

---

how to sort two columns in single job in datastage.

1 Answers   TCS,

---

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers  

---

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

12 Answers   Wipro,

---

Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,

---