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
- 19000 Views
- I also Faced
- E-Mail Answers
Answer Posted / gd
First override source qualifier
Select * from emp where deptno in(10,20,30);
Next sorter T/r sort on salary column desc
Then rank T/r set rank properties top and number of ranks is 5
target achieved
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
How do you migrate data from one environment to another?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the types of presistent cache in look up tr.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is the difference between writing a joiner query in ANSI style and THETA style?
Define enterprise data warehousing?
How to load a Dimension ? and how to load a fact table?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How many numbers of sessions can one group in batches?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Do you find any difficulty while working with flat files as source and target?
Could you explain what is enterprise data warehouse?
How to Create a folder using pmrep command?
What is workflow? What are the components of workflow manager?
What are the uses of etl tools?
