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
Design time, run time. If you don't create parameter what will happen
difference between repository database and repository service?
Separate from an archive server and a powerhouse?
What is union transformation?
Target increases every day even though no new record was inserted
What is dimensional table?
What is intricate mapping?
Explain transaction control transformation in informatica
what is INFORMATICA TESTING process
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is domain and gateway node?
Explain the types of lookup transformation?
How many number of sessions can one group in batches?