Interested to Buy Any Domain ? << Click Here >> for more details...
Disply the dname wise maximum salary
- 9 Answers
- 11833 Views
- Principal Finance, I also Faced
- E-Mail Answers
Answer Posted / reddeppa reddy
select deptid, max(sal) from department table group by sal
| Is This Answer Correct ? | 5 Yes | 15 No |
Post New Answer View All Answers
what is parallel query?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Explain when do we analyze the tables? How do we do it?
I need to set predefined condition. How I do this?
What are the various file formats involved in reportnet?
Explain what are the different types of join operations?
What are the steps involved in creating dimensional modeling process?
What is the difference between datawarehouse and bi?
What are the key columns in Fact and dimension tables?
Difference between e-r modeling and dimentional modeling?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain what are the various transformation available?
Explain why dimenstion tables are denormalized in nature?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
