Retrieving first and last record from a table/file

How to get first and last record from a table/file?

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.

Powered by Blogger.