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
- 16632 Views
- I also Faced
- E-Mail Answers
Answer Posted / sujana
@above
in rank also v hav grpby option..no need 2 use aggregator
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Performance tuning( what you did in performance tuning)
What is expression transformation?
How to generate sequence numbers without using the sequence generator transformation?
can u any challenge your project?
Explain what are the different versions of informatica?
where to store informatica rejected data?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How can you define user defied event?
What do you understand by SOA of Informatica?
What is the difference between Active and Passive transformation?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
scenario where i can use only concurrent execution of workflow.
Explain pushdown optimization and types in informatica
How to create or import flat file definition in to the warehouse designer?
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?
