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
Clarify the utilization of aggregator cache record?
What is a sorter transformation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Explain load alternative records / rows into multiple targets - informatica
what is unit testing?tell me proceedure
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is incremental aggregation?
Explain the types of lookup transformation?
what is INFORMATICA TESTING process
During the running session, output files are created by informatica server. Enlist few of them.
Explain target update override in informatica
How to handle decimal places while importing a flatfile into informatica?
Slowly changing dimensions, types and where will you use them
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Design a mapping to load a target table with the following values from the above source?