What is the query to find nth highest salary?
What is the use of cursors?

Answer Posted / chandrasekar

Hi Suraj,

Your SQL query is not working? so please try in oracle and
once again load to site.

Thanks for ur help.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Whats there in global repository

1272


How do you set a varible in incremental aggregation

1451


What is informatica?

682


What is aggregate cache in aggregator transformation?

635


Explain what are the different versions of informatica?

655






What are the new features of Power Center 5.0?

1234


What is mapping debugger?

574


How to call shell scripts from informatica?

577


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6757


Explain incremental aggregation in informatica

654


How to do unit testing in informatica? How to load data in informatica ?

653


What's the layout of parameter file (what does a parameter file contain?)?

1917


On which transformations you created partitions in your project?

761


Describe an informatica powercenter?

609


What is domain and gateway node?

698