Pages

Sunday, March 17, 2013

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

No comments:

Post a Comment