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 some differences between 7.x and 8.x version of datastage?

0 Answers  

---

what is operator combinality in datastage?

1 Answers   TCS,

---

what are the different type of errors in datastage?

2 Answers   Wipro,

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

0 Answers  

---

how to unlock a locked job in datastage 8.0

3 Answers   HCL,

---

---

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers   TCS,

---

What modeling tool do you use?

6 Answers   HP,

---

How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers   IBM,

---

What is the process of killing a job in datastage?

0 Answers  

---

3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 Answers  

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

0 Answers  

---

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq

9 Answers   Patni,

---