Get top 5 records to target without using rank

  • Drag source and target to the mapping and connect source qualifier to the sorter transformation. 
  • Arrange Sal column in descending order, connect it to expression transformation and sequence generator. 
  • Add NEXTVAL port from sequence generator to the expression transformation. 
  • Connect expression transformation to the filter Transformation and set the filter condition NEXTVAL<=5 

  • Connect filter transformation to the target. 

Powered by Blogger.