Interested to Buy Any Domain ? << Click Here >> for more details...
If a table contains 100 records we have to fetch 50-100
records from source to target?how
- 7 Answers
- 12432 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / udit
If the question is like they want to load next half record then we write query in source qualifier
select * from table
minus
Select * from table
where rownum<=(select count(*)/2 from table)
this query will load the next half i.e. from 50 to 100 records
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a pre-defined event and user-defined event?
can anyone explain me about retail domain project in informatica?
Explain in detail about scd type 1 through mapping.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is a predefined event?
How many ways a relational source definition can be updated and what are they?
How would you copy the content of one repository to another repository?
What does reusable transformation mean?
What are connected or unconnected transformations?
How to generate sequence numbers without using the sequence generator transformation?
Make a note of the quantity vaults made in informatica?
What are the measure objects?
Enlist the various types of transformations.
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the designer tools for creating transformations?
