Interested to Buy Any Domain ? << Click Here >> for more details...
in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
- 11 Answers
- 34516 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anoymous
override source qualifier
select * from tablename where rownum=1 and rownum=10;
| Is This Answer Correct ? | 4 Yes | 16 No |
Difference between Data and Index Caches?
Define mapping and session?
how to join the two flatfiles using the joiner t/r if there is no matching port?
Router T/R is active but some people are saying it is also passive which is exactly right?
What are the connected or unconnected transforamations?
Under what condition selecting sorted input in aggregator may fail the session?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y
What are the new features of the server manager in the informatica 5.0?
Can we override a native sql query within informatica?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
What are the types of caches in lookup?
Teradata 
