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
- 6719 Views
- Reliance, I also Faced
- E-Mail Answers
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 |
What all are the different way to run a job?
how can we create tables in datastage?
How many types of sorting methods are available in datastage?
Explain the importance of surrogate key in data warehousing?
What are the different database update actions available?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...
Differentiate between operational datastage (ods) and data warehouse?
What is the use of surrogate key stage?
What is the difference between orabulk and bcp stages?
What is the process of killing a job in datastage?
what is A Datastage?
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
Teradata 
