How to list Top 10 salary, without using Rank Transmission?
Answer Posted / ramu
Use source Qualifier Transformation,we can edit the default
sql query and write like as
select * from ( select * from emp
order by sal desc)
where rownum <11;
| Is This Answer Correct ? | 29 Yes | 2 No |
Post New Answer View All Answers
How to create a non-reusable instance of reusable transformations?
what is the hint? how to use it to reduce the query processing in program?
What is dimensional table? Explain the different dimensions.
Is there any target staging area in informatica not staging area
Explain your project of banking domian.
What is an expression transformation in informatica?
How many input parameters can exist in an unconnected lookup?
Why do we need informatica?
Which version configuration tool used in ur project?
What is domain and gateway node?
What is the surrogate key?
What are Dimensional table?
When do you use sql override in a lookup transformation?
What is informatica powercenter repository?
Explain the different lookup methods used in informatica?