1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / tallamaheshgoud


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 the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers   IBM,

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 Answers   IBM,

On which Dimension Table you implemented SCD Type in your Project

0 Answers  

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

0 Answers  

What r the existing server jobs in parallalism?

0 Answers   ITC Infotech,




1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

4 Answers   Wipro,

how can u find out the datastage job is running on how many nodes

7 Answers   IBM,

Explain the ChangeApply stage?

11 Answers  

I have a few records just I want to store data in to targets cycling way how?

0 Answers   Polaris,

Define project in datastage?

0 Answers  

If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,

For more Data Stage Interview Questions Click Here
Categories