In a table, 4 person having same salary. How to get Third person record only?

Question

Design a mapping to load the first record from a flat file into one table A, the last record from a flat file into table B and the remaining records into table C?

Answer 1

id sal

101 1000

102 1000

103 1000

104 1000

select id, sal from emp where rownum<=3

minus

select id, sal from emp wwhere rownum<=2;

Or

Use a Sequence Generator Transformation,selet Start value = 1 and Increment By = 1.

Use a Filter Transformation,take the ports Person and Salary from source qualifier and the NEXTVAL port from 
Sequence Generator Transformation into it.Set the filter condition NEXTVAL = 3.