Use aggregator without any group by ports which will give last record by default--Sadik
use sequence generator t/r in exp t/r. use sorter t/r for descending . and use filter t/r to get n top numbers.
Is it possible to this with Rank tr. ?
Use SNO=CURVAL from SG to find out last record.Then select SNO-N records
use variable port to generate ids in exp transvariable port vid(integer) = vid+1;output port oid(integet)=vid;pass data to sorter, sort by oid descnow pass data to exp tr, again generate ids variable port vidN(integer) = vidN+1;output port oidN(integet)=vidN;pass data to filter on oidN=Mwe can do through Rank trans also, after generating ids in exp trans... pass data to Rank trans and select top M ranks, rank port need to be oid port
Copyright © 2015 mkashu. Designed by Templateism