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
Explain dynamic target flat file name generation in informatica
What is complex mapping?
Is it possible to define a single node as a Gateway node as well as worker node?
To import the flat file definition into the designer where should the flat file be placed?
Write the unconnected lookup syntax and how to return more than one column.
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. ?
can we override a native sql query within informatica? How do we do it?
Design a mapping to load a target table with the following values from the above source?
What are the tasks that source qualifier perform?
What is a sorter transformation?
How do you load unique records into one target table and duplicate records into a different target table?
How many ways are there to do 'remove duplicate records in informatica'?
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?
How can we handle two sessions in informatica?
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