Interested to Buy Any Domain ? << Click Here >> for more details...
How to Display top 2 salaries for each department WITHOUT
using Rank Transformation And WITHOUT using SQL queries in
source qualifier.
- 3 Answers
- 20685 Views
- Eureka Forbes, I also Faced
- E-Mail Answers
Answer Posted / ahmed
Use Sorter transformation,apply sort key on sal Col as Desc
and use seq Gen transformation then apply filter on first
two seq numbers...
| Is This Answer Correct ? | 9 Yes | 13 No |
Post New Answer View All Answers
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is the status code in stored procedure transformation?
Can u generate reports in Informatica?
Which version configuration tool used in ur project?
What is rank index in rank transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is a stored procedure transformation?
What is the surrogate key?
What are the different ways to implement parallel processing in informatica?
What is the function of union transformation?
What is Data Caches size?
What is a passive transformation?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How to update or delete the rows in a target, which do not have key fields?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
