i think there is no function on rank , you can write a sql query for that

what is the function in Transformer stage can act as Rank
function in Oracle

Question Posted / prasad

Answer Posted / prasad

i think there is no function on rank , you can write a sql
query for that one in oracle stage or drs stage/

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can you explain repository tables in datastage?

1397

Difference between data warehousing and olap?

1085

What is a quality stage in datastage tool?

1071

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1206

What are the some differences between 7.x and 8.x version of datastage?

1253

Can you implement SCD2 using join, transformer and funnel stage?

1545

What is the different type of jobs in datastage?

962

What are the repository tables in datastage?

1301

What are some prerequisites for datastage?

1092

EXPLAIN SCD

1389

Triggers,VIEW,Procedures

1214

What are the different kinds of views available in a datastage director?

1026

What is the purpose of pivot stage and types of containers in datastage

1031

what is flow of project?

1993

Define APT_CONFIG in Datastage?

1066