Use sequential stage with rownumbers. Then filter out rownum = 0(that will be your first record). Then sort the other data in descending order. Send the sorted data to a transformer, use a stagevariable svval with initial value as 0. In the derivation for svval use svval + 1. The transformer should have two output links. The constraint for the first link is svval != 1 (that will be all the records but last), the constraint for the second link will be svval = 1 (This will be the last record).