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
- 18618 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 why we use partitioning the session in informatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
what is mean by complex business rule ?
what is size of u r database?
How to generate sequence numbers without using the sequence generator transformation?
How can informatica be used for an organization?
What are the databases that informatica can connect to windows?
How big was your fact table
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is rank transformation?
What is meant by target load plan?
What is informatica?
What are the informatica performance improvement tips
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Differences between version 7.x and 8.x.
