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
- 10534 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
Can anyone tell me the new features in Informatica 9 Version?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is update strategy transform?
What is the format of informatica objects in a repository?
How to create the source and target database connections in server manager?
Enlist the various types of transformations.
What is workflow? What are the components of the workflow manager?
What is the difference between informatica 7.0 and 8.0?
What are the types of presistent cache in look up tr.
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are the designer tools for creating transformations?
Explain the shared cache and re-cache?
tell me the rules and responsblites in our project(my project is development)
How can we remove the duplicates from flat file source?
