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

what is .dsx files

3 Answers   IBM,


Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,


whats difference between ls -ltr and ls -lrt?

5 Answers   L&T,


parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  


types of errors in datastage?

2 Answers   Reliance,


what is the use of surogate key in datastage

0 Answers   TCS,


How to lode data in sequntional files perform faster?

1 Answers   Polaris,


What is a datastage job?

0 Answers  


Distinguish between informatica & datastage. Which one would you choose and why?

0 Answers  


Name the command line functions to import and export the DS jobs?

0 Answers  


What are the main differences you have observed between 7.x and 8.x version of datastage?

0 Answers  


What is the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers   IBM,


Categories