Scenario 4:

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

Solution:

Step  1: Drag and drop ports from source qualifier to two rank transformations.

src to rank

Step  2: Create a reusable sequence generator having start value 1 and connect the next value to both rank transformations.

seq to rank

Step  3: Set rank properties as follows

In Rank1

rank 1 properties

In Rank2

rank 2 properties

Step  4: Make two instances of the target.

Step  5: Connect the output port to target.

Scenario 4 Final