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
What are the types of schemas we have in data warehouse and what are the difference between them?
Explain direct and indirect flat file loading (source file type) - informatica
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the restrictions of union transformation?
What is data movement mode in Informatica and difference between them?
tell me the rules and responsblites in our project(my project is development)
Parameter and variable differences
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How many number of sessions can one group in batches?
How identifying bottlenecks in various components of informatica and resolving them?
how to load rows into fact table in data warehouse
Can you generate sequence numbers without using the sequence generator transformation?
Repository user profiles
Performance tuning( what you did in performance tuning)
What do you understand by a term domain?