What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / tina
select min(sal)
from tablename
where sal in
(select top n-1 sal from tablename order by sal desc)
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Partition, what happens if the specified key range is shorter and longer
Global and Local shortcuts. Advantages.
What is repository manager?
How many number of sessions can one group in batches?
How to differentiate between the active and passive transformations?
Define joiner transformation?
Explain the informatica workflow?
What is session task and command task?
How to delete duplicate row using informatica?
Performance tuning( what you did in performance tuning)
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
Design a mapping to load a target table with the following values from the above source?
What is the difference between informatics 7x and 8x and what is latest version?
What are the different types of transformation available in informatica.
How to load the data from people soft hrm to people soft erm using informatica?