What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / sree
select sal from emp e where nth=(select count(*) from emp
where sal>e.sal);
| Is This Answer Correct ? | 5 Yes | 12 No |
Post New Answer View All Answers
What is data caches/ index caches?
How does a rank transform differ from aggregator transform functions max and min?
How do you take back up of repository?
pmscmd startworkflow -sv
What is source qualifier transformation in informatica?
What are the advantages of using informatica as an etl tool over teradata?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Separate from an archive server and a powerhouse?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Write the unconnected lookup syntax and how to return more than one column.
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
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
COM components can be used in Informatica
In informatics server which files are created during the session rums?
How do you promote a non-reusable transformation to reusable transformation?