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
- 17142 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 the way to execute pl/sql script using informatica mapping?
What is the meaning of decode in informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Is it possible to define a single node as a Gateway node as well as worker node?
What is informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
what is song in infrmatica...?
How we can create indexes after completing the load process?
Implementation methodology
What is a predefined event?
What are the different types of repositories created using informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is target load order?
Do you find any difficulty while working with flat files as source and target?
What is native users?
