By using Transformation i need top most 5 employee salary
from each deptwise? Deptno 10,20,30? which transformation
we need to use?
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
Scheduling properties,whats the default (sequential)
What are the components of workflow manager?
In development project what is the process to follow for an etl developer from day1
How to differentiate between the active and passive transformations?
What is a repository? And how to add it in an informatica client?
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
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is sq transformation?
What is the difference between router and filter?
What is update strategy transform?
What is union transformation in informatica?
What differs when we choose the sorted input for aggregator transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
How does a rank transform differ from aggregator transform functions max and min?