Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 19174 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 = 30 order by Sal desc
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is rank index in rank transformation?
tell me 5 session failure in real time how can you solve that in your project?
How many ways a relational source definition can be updated and what are they?
How can a transformation be made reusable?
Under which circumstances, informatica server creates reject files?
How do you load alternate records into different tables through mapping flow?
What are the different versions of informatica?
Define enterprise data warehousing?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How to extract sap data using informatica? What is abap? What are idocs?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How are the sources and targets definitions imported in informatica designer?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is domain and gateway node?
