What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / sbvp
select * from table name where sal in ( select * from
(select distinct sal from tablename order by sal desc)
where rownum<=&n);
if there is any another query plz tell me r mail me
Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
Can you generate sequence numbers without using the sequence generator transformation?
Define enterprise data warehousing?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is the status code in stored procedure transformation?
Explain your project of banking domian.
what is the difference between informatica6.1 and infomatica7.1
What are the types of schemas we have in data warehouse and what are the difference between them?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Under what condition selecting sorted input in aggregator may fail the session?
Explain the use of aggregator cache file?
Write the program through which the records can be updated?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is informatica? Why do we need it?