sekharchandra


{ City } chennai
< Country > india
* Profession *
User No # 54142
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 4
Users Marked my Answers as Wrong # 6
Questions / { sekharchandra }
Questions Answers Category Views Company eMail




Answers / { sekharchandra }

Question { L&T, 7364 }

when we use dynamic lookup,if condition matches what will be
the o/p?


Answer

This lookup property is recomended only for the mapping
where soures has duplicate records

Is This Answer Correct ?    2 Yes 3 No

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

Is This Answer Correct ?    2 Yes 3 No