in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
Answer Posted / anoymous
override source qualifier
select * from tablename where rownum=1 and rownum=10;
Is This Answer Correct ? | 4 Yes | 16 No |
Post New Answer View All Answers
How to Create a folder using pmrep command?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are junk dimensions?
What is a code page?
What is the cumulative sum and moving sum?
can anyone explain me about retail domain project in informatica?
How many ways are there to create ports?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is lookup transformation?
What is the benefit of session partitioning?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is the Rank index port in Rank transformation?
Explain the shared cache and re-cache?
What are the guidelines to be followed while using union transformation?
What all join we can perform in LOOKUP transformation?