What is the function in Transformer stage can act as Rank
Function in oracle



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

Post New Answer

More Data Stage Interview Questions

Name the third party tools that can be used in datastage?

0 Answers  


what is meant by port ? what is the use of port ? what are the different type of ports and its usage

2 Answers   Accenture,


How do you find the number of rows in a sequential file?

1 Answers  


what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,


How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,






How can we run same job in 1 day 2 times

4 Answers   IBM,


Define repository tables in datastage?

0 Answers  


what is the differeces between hash and modulus partition methods

4 Answers   TCS,


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

0 Answers  


Difference between server jobs & parallel jobs?

0 Answers  


My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.

6 Answers   Wipro,


What are the differences between datastage and informatica?

0 Answers  


Categories