Interested to Buy Any Domain ? << Click Here >> for more details...
which transformation should we use to get the 5th rank
member from a table in informatica?can we achieve this in
sql?
- 6 Answers
- 10937 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bhaskar
select * from(select * from emp order by sal desc)
where rownum<=5
MINUS
select * from(select * from emp order by sal desc)
where rownum<=4
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How can you increase the performance in joiner transformation?
Performance tuning( what you did in performance tuning)
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How to use pmcmd utility command?
How many dimensions are there in informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is the use of transformation?
Repository user profiles
Explain the use of aggregator cache file?
What is workflow manager?
What is the difference between informatics 7x and 8x and what is latest version?
what is the size of your data warehousing?
How big was your fact table
Briefly describe lookup transformation?
What is mapping debugger?
