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 = 30 order by Sal desc
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
what is INFORMATICA TESTING process
Scheduling properties,whats the default (sequential)
Informatica Checkpoints
What is repository manager?
What are the tasks that source qualifier perform?
what is unit testing?tell me proceedure
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Implementation methodology
What are batches?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is option by which we can run all the sessions in a batch simultaneously?
How you know when to use a static cache and dynamic cache in lookup transformation?
Explain what are the different versions of informatica?