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 / sathish

source may be flat file or database just you use sequence ganarater then filter copy the nextval port to filter write condition nextval=1 or nextval=10 you get only 1 and 10 th records

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the main issues while working with flat files as source and as targets ?

657


Differentiate between Load Manager and DTM?

1667


Define enterprise data warehousing?

636


expain about the tune parameters?

1888


What are the different versions of informatica?

680






I have a flat file, want to reverse the contents of the flat file

695


Name at least 5 different types of transformations used in mapping design and state the use of each.?

670


What is parallel processing in informatica?

1031


EXL informatica Questions

938


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4786


Difference between Data and Index Caches?

660


What is the benefit of partitioning a session?

631


can we override a native sql query within informatica? Where do we do it?

626


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1706


Which are the different editions of informatica powercenter that are available?

558