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

Answer Posted / informatica_learner

use sorter--> expression-->filter
1)sorter descend
2)use sequence generator connected expression to generator
sequence,
3)filter the value sequence number greater than 10

Is This Answer Correct ?    27 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we remove the duplicates from flat file source?

583


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

812


What is the maplet?

622


What is the reusable transformation?

632


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

4793






What are the different components of powercenter?

586


What if the source is a flat-file?

595


How can we store previous session logs?

569


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1463


scenario where i can use only concurrent execution of workflow.

2551


How to create or import flat file definition in to the warehouse designer?

618


what is the Default Source Option For Update Strategy Transformation?

759


How many numbers of sessions can one group in batches?

625


what is Active lock explain

2374


What are junk dimensions?

636