If a table contains 100 records we have to fetch 50-100
records from source to target?how

Answer Posted / tauseef

hai Tauseef,

as per my knowledge we can Fetch 50-100 records
by using rownum>=50 in source qualifier it self after generation sql query

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to generate sequence numbers?

616


What are some examples of informatica etl programs?

531


Explain the different lookup methods used in informatica?

585


Differentiate between sessions and batches?

570


Explain the use of aggregator cache file?

671






Explain sessions?

602


what is Active lock explain

2365


What is the session task and command task?

593


What is a filter transformation?

563


What are the components of the workflow manager?

635


Explain what is informatica metadata and where is it stored?

604


What are the different clients of powercenter?

594


What is persistent lookup cache?

598


What is xml source qualifier transformation in informatica?

710


What is aggregator transformation in informatica?

539