venkat

• Mar 28th, 2016

 

use dense_rank() SQL function and use Sort stage.

Ram

• Mar 28th, 2016

 

Src-->sort(desc)-->Trnsfrm(3 stage variables & generate Rank col) --> trg.
Transform Derivation for Rank column:
Initialize Stgv1,Stgv2,Stgv3=0
stgv1=Sal
stgv2=>if stgv1=stgv3 then stgv2 else stgv2+1
stgv3=stgv1

Reddy

• Apr 1st, 2016

 

3 stage variables:
sal : stgVar1
((sal< >presal and sal > presal) or(sal=presal)) then 1 else 0 : StgVar2
stgVar1 :presal
1 :Rank
if StgVar2=1 then Rank else Rank++ :RankVal