Answer Posted / 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 a folder? Difference types of stages?

1102

---

What is the different type of jobs in datastage?

900

---

How do you import and export data into datastage?

1165

---

What are the functionalities of link collector?

1036

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2549

---

What are the different layers in the information server architecture?

1076

---

What is the difference between Datastage 7.5 and 7.0?

1048

---

Define Job control?

1060

---

What are orabulk and bcp stages?

1067

---

What are the types of containers in datastage?

1143

---

What is the difference between an operational datastage and a data warehouse?

1088

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2836

---

Define APT_CONFIG in Datastage?

1019

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1368

---

How many Key we can define in remove duplicate stage?

1310

---