What is the function in Transformer stage can act as Rank
Function in oracle
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to RD using transformer?
Can you explain how could anyone drop the index before loading the data in target in datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
Describe the main features of datastage?
What is oci?
Triggers,VIEW,Procedures
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the types of containers?
What are some prerequisites for datastage?
How many Key we can define in remove duplicate stage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
describe the Steps to confiure a Qlogic switch
What are stage variables and constants?
How to find value from a column in a dataset?
What is the purpose of pivot stage and types of containers in datastage