Interested to Buy Any Domain ? << Click Here >> for more details...
What is the query to find nth highest salary?
What is the use of cursors?
- 8 Answers
- 21396 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answer Posted / venky
select * from emp e where &n=(select count(distinct(b.sal))
from emp b where e.sal=b.sal);
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Explain the shared cache and re-cache?
whats the logic to load the lower level of granularity of data to fact table.
What is a difference between complete, stop and abort?
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
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are Dimensional table?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain Dataware house architecture .how data flow from intial to end?
Explain the types of transformations?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Different circumstance which drives informatica server to expel records?
What is target load order?
Different sorts of metadata that stores in the storage facility?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
