Use Aggregator as Transformation with MAX and 2 outputs

How to Display top 2 salaries for each department WITHOUT
using Rank Transformation And WITHOUT using SQL queries in
source qualifier.

Question Posted / dave

Answer Posted / dave

Is This Answer Correct ?

0 Yes

10 No

Please Help Members By Posting Answers For Below Questions

Define Pmrep command?

1054

What are the static cache and dynamic cache in informatica?

1186

How to configure mapping in informatica?

1173

How do you change a non-reusable transformation to reusable transformation?

997

How can you generate reports in informatica?

1025

What is the difference between informatica 7.0 and 8.0?

1013

Write the advantages of partitioning a session?

1278

Explain the different kinds of facts.

979

Explain dynamic target flat file name generation in informatica

1048

Explain in detail scd type 2 through mapping.

1039

What is the scenario which compels informatica server to reject files?

1070

How are indexes created after completing the load process?

1640

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2151

explain one complex mapping with logic? sales project?

6668

What is the need of an ETL tool?

1085