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 |
How do you run datastage job from the command line?
How can we run same job in 1 day 2 times
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
What are some different alternative commands associated with "dsjob"?
What are orabulk and bcp stages?
How do u call shellscript/Batch file from DS?
What are the third party tools you used in your project?
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
What are the different database update actions available?
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
If you want to use a same piece of code in different jobs, how will you achieve this?