By using Transformation i need top most 5 employee salary
from each deptwise? Deptno 10,20,30? which transformation
we need to use?
- 8 Answers
- 17146 Views
- I also Faced
- E-Mail Answers
Answer Posted / jay
Override SQL in source qualifies with bellow query
Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 10 order by Sal desc
Union All
Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 20 order by Sal desc
Union All
Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 20 order by Sal desc
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Define mapping and session?
What is the cumulative sum and moving sum?
Write the different tools in the workflow manager?
What are the various types of transformation?
What is the function of look up transformation?
How do you change a non-reusable transformation to reusable transformation?
Explain lookup transformation in informatica
What is domain in terms of informatica?
How to generate sequence numbers without using the sequence generator transformation?
tell me the rules and responsblites in our project(my project is development)
Tell me about Propagate functions in informatica
What is meant by LDAP users?
How does a rank transform differ from aggregator transform functions max and min?
What is meant by a domain?
How can we create index after completion of load process?
