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
- 34320 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / chandra
override source qualifier
SELECT E.* FROM(SELECT ENAME,SAL,ROWNUM R FROM EMP) E WHERE
R IN (1,5);
HERE I TAKE EMP TABLE
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How does a sorter cache works?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are the advantages of using informatica as an etl tool over teradata?
draw informatica architecture 8.6 ?
Explain what is informatica metadata and where is it stored?
expain about the tune parameters?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is standalone command task?
difference between informatica 8.1.1 and 8.6
Repository user profiles
How do you handle two sessions in Informatica
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is a router transformation?
