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



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

Answer / 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

Post New Answer

More Data Stage Interview Questions

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,


What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  


How many types of sorting methods are available in datastage?

0 Answers  


Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

4 Answers   IBM, PR3 Systems,


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,






How to implement complex jobs in data stage?

0 Answers  


how many write modes are there in ds

2 Answers   IBM,


Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,


source file is having 5 records while moving into target it want to be 10 records

4 Answers   IBM,


I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

6 Answers  


What is the difference between in process and inter process?

0 Answers  


You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?

1 Answers   TIAA CREF,


Categories