Use Sorter transformation,apply sort key on sal Col as Desc and use seq G

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

Question Posted / ahmed

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

Please Help Members By Posting Answers For Below Questions

what is the Default Source Option For Update Strategy Transformation?

1241

Differentiate between reusable transformation and mapplet.

1097

How to generate sequence numbers without using the sequence generator transformation?

1207

Define pmcmd command?

1047

Separate from an archive server and a powerhouse?

964

Which transformation should we use to normalise the COBOL and relational sources?

1213

What is sorter transformation?

1048

Differentiate between a repository server and a powerhouse?

1119

what is index?how it can work in informatica

2041

What are the limitations of joiner transformation?

1114

Write the unconnected lookup syntax and how to return more than one column.

1110

What is main use of mapplet?

1133

I have a flat file, want to reverse the contents of the flat file

1128

How can we remove the duplicates from flat file source?

1040

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5676