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
- 18989 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
Define Pmrep command?
What is the need of etl tools?
What is dimensional table?
Difference between Data and Index Caches?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is an expression transformation in informatica?
Can anyone tell me the new features in Informatica 9 Version?
what is SDLC way of code development?
What is DR strategy for Informatica project?
How are indexes created after completing the load process?
Have you worked with/created Parameter file
What can we do to improve the performance of informatica aggregator transformation?
What is the difference between informatica 7.0 and 8.0?
What is the difference between a repository server and a powerhouse?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
