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
- 18883 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
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Why is sorter an active transformation?
What is powercenter on grid?
How can informatica be used for an organization?
where to store informatica rejected data? How to extract the informatica rejected data?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are Dimensional table?
what is the Default Source Option For Update Strategy Transformation?
Where can we find the throughput option in informatica?
What are session parameters ? How do you set them?
What is Data Caches size?
Why filter transformation is an active one?
What is decode in static cache?
Write the advantages of partitioning a session?
hi real timers . iam waiting for ur reply regarding ETL TESTING
