Interested to Buy Any Domain ? << Click Here >> for more details...
What is the function in Transformer stage can act as Rank
Function in oracle
- 1 Answers
- 6711 Views
- Reliance, I also Faced
- E-Mail Answers
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
Can you explain repository tables in datastage?
What is datastage engine?
What are orabulk and bcp stages?
How do you reject records in a transformer?
Why do you need stage variables?
How do u convert the columns to rows in datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are the different kinds of views available in a datastage director?
What are some different alternative commands associated with "dsjob"?
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 importance of the exception activity in datastage?
Can you filter data in hashed file?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Explain usage analysis in datastage?
Differentiate between hash file and sequential file?
