How to list Top 10 salary, without using Rank Transmission?

Answer Posted / giri

First use sorter with salary based and sequent generator next filter transformation

Sorter(salary desending order)-----> Sequent genarator

--------->Filter(seq<=10)

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain dynamic target flat file name generation in informatica

732


What is complex mapping?

756


Is it possible to define a single node as a Gateway node as well as worker node?

763


To import the flat file definition into the designer where should the flat file be placed?

748


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

699






How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1691


can we override a native sql query within informatica? How do we do it?

744


Design a mapping to load a target table with the following values from the above source?

977


What are the tasks that source qualifier perform?

722


What is a sorter transformation?

783


How do you load unique records into one target table and duplicate records into a different target table?

828


How many ways are there to do 'remove duplicate records in informatica'?

672


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

699


How can we handle two sessions in informatica?

691


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1788