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
- 18958 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 pushdown optimization $pushdownconfig parameter - informatica
Where can we find the throughput option in informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to start a workflow using pmcmd command?
What do you mean by enterprise data warehousing?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
what is the size of u r source(like file or table)?
Design time, run time. If you don't create parameter what will happen
Explain the code page compatibility?
What is the way to execute pl/sql script using informatica mapping?
While migrating the data from one environment to another environment how would you manage the connections?
How to implement security measures using repository manager?
What do you mean by channel change?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Under which circumstances, informatica server creates reject files?
