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
What is the way to execute pl/sql script using informatica mapping?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What are the new features of informatica 9.x at the developer level?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain about Informatica server process that how it works relates to mapping variables?
What is Session and Batches?
Briefly define reusable transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How can we use mapping variables in informatica? Where do we use them?
What is the function of aggregator transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is informatica?
What are the advantages of informatica?