What is the function in Transformer stage can act as Rank
Function in oracle
- 1 Answers
- 5857 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
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Differentiate between data file and descriptor file?
How will you move hashed file from one location to another location?
How to find value from a column in a dataset?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Can you explain tagbatch restructure operator?
Why do we use exception activity in Datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is ibm datastage flow designer?
in oracle target stage when we use load option and when we use upsert option?
Terminate Activity
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are the types of containers?
