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 is mapping lookup

1 Answers  

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---

1.what is materialized data? 2.how to view the materialized data?

0 Answers   HCL, IBM,

---

why dataset ?

2 Answers  

---

Explain the ChangeApply stage?

11 Answers  

---

SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y

4 Answers  

---

how many types of sorting the data in data stage?

1 Answers   BoA, IBM,

---

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,

---

how can we create tables in datastage?

1 Answers  

---

i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com

2 Answers   Wipro,

---

How to add zero "0" before record in a field?

4 Answers  

---

Explain entity, attribute and relationship in datastage?

1 Answers  

---