What is the function in Transformer stage can act as Rank
Function in oracle
Answer / 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 |
what is .dsx files
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
whats difference between ls -ltr and ls -lrt?
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
types of errors in datastage?
what is the use of surogate key in datastage
How to lode data in sequntional files perform faster?
What is a datastage job?
Distinguish between informatica & datastage. Which one would you choose and why?
Name the command line functions to import and export the DS jobs?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the Difference Between DataStage 7.5 version and 8.1 Version?