Question { L&T, 30837 }
in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
Answer
override source qualifier
SELECT E.* FROM(SELECT ENAME,SAL,ROWNUM R FROM EMP) E WHERE
R IN (1,5);
HERE I TAKE EMP TABLE