how can we load starting with 11th record of a table from
source to target
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
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Is it possible to use a client with different version than that of its Informatica server?
What do you mean by worklet?
Write the program through which the records can be updated?
What is mapplet in informatica?
explain abt ur project architecture?
What all are steps in up gradation of Informatica server?
Where can we find the throughput option in informatica?
Can we get 1st record through Informatica(without sequence number).
How to load last n records of file into target table - informatica
If informatica has its scheduler why using third party scheduler?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are the main features of Oracle 8i with context to datawarehouse?
Mention few power centre client applications with their basic purpose?