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

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1097


How many number of sessions can one group in batches?

705


What is the difference between STOP and ABORT options in Workflow Monitor?

707


What are the static cache and dynamic cache in informatica?

729


What are the main features of Oracle 8i with context to datawarehouse?

1691






What is the difference between a repository server and a powerhouse?

827


What is mapplet in informatica?

607


Enlist the differences between database and data warehouse.

567


Why do you use Mapping Parameter and mapping variable?

1298


Why is sorter an active transformation?

672


Write the different tools in the workflow manager?

583


What is the fact table?

601


How identifying bottlenecks in various components of informatica and resolving them?

593


draw informatica architecture 8.6 ?

3480


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1788