in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
Answer Posted / anoymous
override source qualifier
select * from tablename where rownum=1 and rownum=10;
| Is This Answer Correct ? | 4 Yes | 16 No |
Post New Answer View All Answers
Explain how many types of dimensions are available in informatica?
What is the use of target designer?
What are the performance considerations when working with aggregator transformation?
What is meant by active and passive transformation?
How can repository reports be accessed without sql or other transformations?
How to update or delete the rows in a target, which do not have key fields?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Explain what is informatica metadata and where is it stored?
What is sorter transformation?
What is a node in Informatica?
How to update source definition?
What are the new features of informatica 9.x at the developer level?
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
To import the flat file definition into the designer where should the flat file be placed?
What are the types of presistent cache in look up tr.