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
What are the different layers in the information server architecture?
What are the partitioning techniques available in link partitioner?
How do you schedule or monitoring the job?
What is job control?
What is quality stage?
in oracle target stage when we use load option and when we use upsert option?
How many types of sorting methods are available in datastage?
What is merge stage?
Is possible to create skid in dim,fact tables?
How to reverse the string using SQL?
table actions available in oracle connector?
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
If you want to use the same piece of code in different jobs, how will you achieve it?
What is the different type of jobs in datastage?
Explain the importance of surrogate key in data warehousing?