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

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  


Differentiate between a database and data warehouse?

0 Answers  


wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,


HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,


What does update strategy mean, and what are the different option of it?

0 Answers  






What is the status code?

1 Answers  


What is meant by lookup transformation?

0 Answers  


How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

0 Answers  


with out using update strategy transnsformation how to update the data in mapping level

1 Answers  


Explain the scenario which compels informatica server to reject files?

0 Answers  


what is mystery dimension?

1 Answers  


Categories