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
Mention a few design and development best practices for informatica?
What is native users?
Differences between connected and unconnected lookup?
What is the function of union transformation?
What is the sql query overwrite in source qualifier in informatica
I have a flat file, want to reverse the contents of the flat file
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Define mapplet?
What is a predefined event?
What is the meaning of up gradation of repository?
Explain what are the different types of transformation available in informatica.
whats the logic to load the lower level of granularity of data to fact table.
Explain load alternative records / rows into multiple targets - informatica