how can we load starting with 11th record of a table from
source to target
- 6 Answers
- 9644 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 a transaction control transformation?
Define mapplet?
What is a joiner transformation?
Different sorts of metadata that stores in the storage facility?
What all join we can perform in LOOKUP transformation?
What is meant by a domain?
How to do unit testing in informatica? How to load data in informatica ?
what is INFORMATICA TESTING process
What is a repository manager?
Explain the shared cache and re-cache?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Can u generate reports in Informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
What is a mapplet/worklet in informatica?
how to create user defined function (udf) in informatica
