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.

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno 1                                2 3 4 5 6 7 8 9 10                                                                                             

5 Answers   Tech Mahindra,

---

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,

---

how to handle null values using transformer stage?

1 Answers  

---

how can u handle null values in transformer stage.

7 Answers  

---

how to handle null values in sequential file?

1 Answers   HCL,

---

what is meta data? Explain? Where it is used?

9 Answers  

---

i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 Answers  

---

Define Data Stage?

0 Answers  

---

why we use hash file for lookup?

5 Answers  

---

What r the existing server jobs in parallalism?

0 Answers   ITC Infotech,

---

how many types of remove the duplicate records?

3 Answers   Caterpillar,

---

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  

---