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
Quickly characterize reusable change?
What is the function of look up transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are the components of the workflow manager?
How can we update a record in the target table without using update strategy?
How does the aggregator transformation handle null values?
How can repository reports be accessed without sql or other transformations?
What is fact table? Explain the different kinds of facts.
What is a connected transformation?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are the types of caches in lookup? Explain them.
What are data-driven sessions?
How to partition the Session?
Explain scd type 3 through mapping.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?