in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?

Answers were Sorted based on User's Feedback



in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method..

Answer / anoymous

override source qualifier

select * from tablename where rownum=1 and rownum=10;

Is This Answer Correct ?    4 Yes 16 No

Post New Answer

More Informatica Interview Questions

can we use cartesian join in informatica

3 Answers   IBM,


can anyone suggest best free Talend data integration training online

0 Answers  


By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,


Define pmcmd command?

0 Answers  


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  






write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,


What are the out put files that the informatica server creates during the session running?

2 Answers  


what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  


Explain joiner transformation in informatica

0 Answers   Informatica,


How we can create indexes after completing the loan process?

0 Answers  


How many input parameters can exist in an unconnected lookup?

0 Answers  


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  


Categories