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

i think there is no function on rank , you can write a sql
query for that one in oracle stage or drs stage/

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Data Stage Interview Questions

How many areas for files does datastage have?

0 Answers  


which r the connectors used in san?

0 Answers  


source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers   IBM,


How many input links can you give to a Transformer stage?

6 Answers  


What are the different plug-ins stages used in your projects?

0 Answers  






How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.

5 Answers  


Can you implement SCD2 using join, transformer and funnel stage?

0 Answers   Cognizant,


DataStage Scenario based Interview Questions

1 Answers  


i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

8 Answers   IBM,


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 is meta stage?

0 Answers  


how to find out number of records imported into source file?

1 Answers  


Categories