Interested to Buy Any Domain ? << Click Here >> for more details...
how can we load starting with 11th record of a table from
source to target
- 6 Answers
- 10971 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / akash
This scenario can also be implemented by using the
following query in Source Qualifier:
select * from table_name where rowid not in (select rowid
from table_name where rownum <= 10)
This will give the records after 10
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is a mapplet/worklet in informatica?
What is workflow monitor?
What is Index Caches size?
What are the differences between source qualifier and joiner transformation?
Explain lookup transformation is active in informatica
What are the databases that informatica can connect to windows?
What is the reusable transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is meant by active and passive transformation?
How to do unit testing in informatica?
What differs when we choose the sorted input for aggregator transformation?
What is dimensional table? Explain the different dimensions.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is sorter transformation?
