select id, sal from emp where rownum<=3
select id, sal from emp wwhere rownum<=2;
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.