how can we load starting with 11th record of a table from
source to target
- 6 Answers
- 8792 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
What is informatica worklet?
Implementation methodology
What are the differences between source qualifier and joiner transformation?
What are the differences between joiner transformation and source qualifier transformation?
What could be the possible resons of locks by user?
What is the difference between a repository server and a powerhouse?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Separate from an archive server and a powerhouse?
Different circumstance which drives informatica server to expel records?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What do you understand by SOA of Informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Difference between Target-based loading and constraint-based loading?
What are active transformations.
Is it possible to define a single node as a Gateway node as well as worker node?
