what is the function in Transformer stage can act as Rank
function in Oracle

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


Please Help Members By Posting Answers For Below Questions

what are the devoleper roles in real time? plz tell i am new to datastage....

1647


How many types of sorting methods are available in datastage?

640


How to reverse the string using unix?

2819


How to read the length of word in unix?

889


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

672






Where do the datastage jobs get stored?

737


Can you explain kafka connector?

782


How one source columns or rows to be loaded in to two different tables?

668


What are system variables and sequencers in datastage

617


How many types of views are there in a datastage director?

841


What are the partitioning techniques available in link partitioner?

1761


which r the connectors used in san?

1799


What is the purpose of pivot stage?

614


how to write server Routine coding?

1671


Describe stream connector?

834