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

According to his methodology what all you need before you build a datawarehouse

1181


How does the aggregator transformation handle null values?

695


Mention a few design and development best practices for informatica?

553


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1313


What is the need of etl tools?

602






how we can load rejected record's at run time?(not through bad files)

1905


How can you increase the performance in joiner transformation?

699


What is meant by incremental aggregation?

576


How can a transformation be made reusable?

658


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5231


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1680


Define mapping and session?

577


Can you generate sequence numbers without using the sequence generator transformation?

595


What are the transformations that are not supported in mapplet?

592


Describe expression transformation?

631