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

Explain connectivity between datastage with datasources?

1041

Name the command line functions to import and export the DS jobs?

1200

why do u need the IOS upgradation in a FC switch

2337

What are the various kinds of containers available in datastage?

1100

What is apt_config in datastage?

1194

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

1350

What are the processing stages?

1151

How do you import and export the datastage jobs?

1209

What is process model?

2025

Can you explain how could anyone drop the index before loading the data in target in datastage?

1548

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2872

How a server job can be converted to a parallel job?

1142

What are stage variables and constants?

1193

What is ds designer?

1163

What are the differences between datastage and informatica?

1229