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

Explain constraint based loading in informatica

838


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1987


What is event and what are the tasks related to it?

831


What do you understand by term role-playing dimension?

784


Explian the Process of deployment groups in informatica

827


How can we remove the duplicates from flat file source?

794


What is the need of an ETL tool?

848


Why filter transformation is an active one?

764


What is source qualifier transformation in informatica?

755


list out all the transformations which use cache?

889


How many ways a relational source definition can be updated and what are they?

796


Describe the impact of several join conditions and join order in a joiner transformation?

831


Partition, what happens if the specified key range is shorter and longer

2222


How to do unit testing in informatica? How to load data in informatica ?

888


tell me the rules and responsblites in our project(my project is development)

1709