How to only last 100 records from a flatfile?

its a easy process.first take source---->SQ----->Rank------>target.
In rank t/r set rank properties as below

top/bottom---------->bottom

number of ranks---->100

Use tail stage n set n=100

Rank solves the problem based on the attribute you are ranking on. if the attribute is not the distinct, then this would not resolve. I also need right answer for this.

You can use the following logic

FF-> SRT(in descending order)=>EXP=> FLT=>TGT
||
SEQ

filter the seq generated values from 1-100 this will load the last 100 values to the target