How to list Top 10 salary, without using Rank Transmission?
Answer Posted / abhilash
do following steps
1.in source qualifier override the query with
"order by salary desc"
2. use seq gen tr on it and give column name as "sid"
3. next use filter tr. in that write condition like "sid<=10"
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
how to create user defined function (udf) in informatica
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How to load a Dimension ? and how to load a fact table?
Which files are created during the session rums by informatics server?
What are pre and post-session shell commands?
What is workflow? What are the components of workflow manager?
design of staging area?
What are the components of Informatica? And what is the purpose of each?
What is difference between a gateway node and worker node?
What is meant by active and passive transformation?
What is informatica metadata and where is it stored?
What is the cumulative sum and moving sum?
What are the designer tools for creating transformations?
can we override a native sql query within informatica? How do we do it?
What is dynamic cache?