empno sal
1 8000
2 9000
3 8000
4 1000 how to get highest sal wise rankings in rank t/r.
Answer Posted / ganesh
write a query like
select * from <table_name> order by where sal=(select max(sal) from <table_name>)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is a pre-defined event and user-defined event?
Scheduling properties,whats the default (sequential)
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is option by which we can run all the sessions in a batch simultaneously?
What is rank transform?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is rank transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
pmscmd startworkflow -sv
where to store informatica rejected data?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Slowly changing dimensions, types and where will you use them
What do you understand by term role-playing dimension?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Define mapplet?