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 |
Name the third party tools that can be used in datastage?
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
How do you find the number of rows in a sequential file?
what is the difference between the active datawarehouse and datawarehouse
How can remove duplicates in a file using UNIX?
How can we run same job in 1 day 2 times
Define repository tables in datastage?
what is the differeces between hash and modulus partition methods
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Difference between server jobs & parallel jobs?
My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.
What are the differences between datastage and informatica?