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 / nish

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a ds designer?

642

What are the different options associated with dsjob command?

945

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

2993

EXPLAIN SCD

967

Differentiate between odbc and drs stage?

593




Why do we use exception activity in Datastage?

724

What are the steps required to kill the job in Datastage?

686

What is the roundrobin collector?

640

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

968

Explain ibm infosphere information server and highlight its main features?

609

What is the purpose of pivot stage?

606

What could be a data source system?

579

How can one find bugs in job sequence?

785

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

349

How a source file is populated?

618