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
- 19181 Views
- I also Faced
- E-Mail Answers
Answer Posted / sujana
v can do dis by using rank tranf... grpby dept no and rankindex=5
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
Under which circumstances, informatica server creates reject files?
Explain lookup transformation source types in informatica
Explain transaction control transformation in informatica
If informatica has its scheduler why using third party scheduler?
Explain what transformation and how many are there in informatica?
How will the document be delivered to me?
What is target load order?
What is Index Caches size?
What are the conditions needed to improve the performance of informatica aggregator transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is difference between a gateway node and worker node?
What are the types of schemas we have in data warehouse and what are the difference between them?
Clarify the utilization of aggregator cache record?
What does update strategy mean, and what are the different option of it?
Explain why we use partitioning the session in informatica?
