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
- 18884 Views
- I also Faced
- E-Mail Answers
Answer Posted / suguna
by using rank transformation rank of salary and aggregator
transformation for group by dept wise
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Define enterprise data warehousing?
What are the tasks that can be performed using sq?
list out all the transformations which use cache?
During the running session, output files are created by informatica server. Enlist few of them.
What is sequence generator transformation in informatica?
How to elaborate powercenter integration service?
What is enterprise data warehousing?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What are the modules in Power Center
What are the popular informatica products?
How many ways are there to do 'remove duplicate records in informatica'?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
The question was on time stamp. what is the difference between HH and HH24 when to use when.
