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 are the types of presistent cache in look up tr.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Have you worked with/created Parameter file
What are the components of the workflow manager?
Is it possible to create multiple domains on a single Informatica server?
Can u generate reports in Informatica?
How to go to the older version for a mapping?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How does the aggregator transformation handle null values?
What are the different types of transformation available in informatica.
What is informatica? Why do we need it?
What do you mean incremental aggregation?
How to use pmcmd utility command?
what is the difference between informatica6.1 and infomatica7.1