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
In warehouses how many schemas are there?
Why filter transformation is an active one?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is a filter transformation and why it is an active one?
What is union transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain the etl program with few examples.
What do you mean by channel change?
How do you take back up of repository?
What are the steps involved in the migration from older version to newer version of Informatica Server?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Why update strategy and union transformations are active?
What is powercenter on grid?
What is expression transformation?
What is meant by active and passive transformation?