How to get first and last record from a table/file?
Solution:
v Drag and drop ports from source qualifier to two rank
transformations.
v Create a reusable sequence generator having start value 1 and
connect the next value to both rank transformations.
v Set rank properties as follows
In Rank1
In Rank2
v Make two instances of the target.
v Connect the output port to target.