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
Difference between sequential file and data set?
how can we create rank using datastage?what is the meaning of rank?
What is orabulk stage?
Define ds designer?
To see hidden files in LINIX?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is the purpose of interprocessor stage in server jobs?
How to implement complex jobs in data stage?
What is aggtorec restructure operator?
Does datastage support slowly changing dimensions ?
sed,awk,head
What are the features of datastage flow designer?
What are the different kinds of views available in a datastage director?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What is the difference between the local container and shared container?