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
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)
How many number of sessions can one group in batches?
What is the difference between STOP and ABORT options in Workflow Monitor?
What are the static cache and dynamic cache in informatica?
What are the main features of Oracle 8i with context to datawarehouse?
What is the difference between a repository server and a powerhouse?
What is mapplet in informatica?
Enlist the differences between database and data warehouse.
Why do you use Mapping Parameter and mapping variable?
Why is sorter an active transformation?
Write the different tools in the workflow manager?
What is the fact table?
How identifying bottlenecks in various components of informatica and resolving them?
draw informatica architecture 8.6 ?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?