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
- 17652 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 degenerated dimension?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is the use of code page?
How can one identify whether mapping is correct or not without connecting session?
Define mapplet?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the databases that informatica can connect to windows?
How does the aggregator transformation handle null values?
What are the new features of Power Center 5.0?
What are the tasks that source qualifier perform?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Define filter transformation?
How can we use mapping variables in informatica?
Define joiner transformation?
