empno sal
1 8000
2 9000
3 8000
4 1000 how to get highest sal wise rankings in rank t/r.
Answer Posted / anoymous
In rank t/r select properties tab
select top and number of ranks is 4
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
what is $$$$?
How can a transformation be made reusable?
How do you change a non-reusable transformation to reusable transformation?
To import the flat file definition into the designer where should the flat file be placed?
Enlist some properties of sessions.
Write the program through which the records can be updated?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What are the new features of informatica 9.x developer?
What are the static cache and dynamic cache in informatica?
What is native users?
EXL informatica Questions
Explain lookup transformation is active in informatica
Explain pmcmd command usage in informatica
What is session task and command task?