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

which is the most complex job in your career? Please tell me answer?

2 Answers   IBM, Wipro,


HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers   ME,


source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,


In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..

2 Answers  


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

0 Answers   CTS,






State the difference between an operational datastage and a data warehouse?

0 Answers  


What are the stages in datastage?

0 Answers  


How a source file is populated?

0 Answers  


what is a force compile

2 Answers   Cap Gemini, IBM,


What is the purpose of pivot stage?

0 Answers  


Tell me Wt main advantage of Stage varibles? Project level hints?

4 Answers   Hexaware,


Can you explain link buffering?

0 Answers  


Categories