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 mapplets? How is it different from a Reusable Transformation?

630


What do mean by local and global repository?

707


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1328


Define update strategy?

641


Explain pushdown optimization and types in informatica

672






Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1595


What is the command used to run a batch?

578


What are the static cache and dynamic cache in informatica?

720


How can we handle two sessions in informatica?

616


What is sq transformation?

669


What is informatica powercenter repository?

715


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1637


What is lookup transformation?

603


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

1593


Explain dynamic target flat file name generation in informatica

652