Answer Posted / vikram

Diff between RANK() and DENSE_RANK():-
------------*******-----************-------

RANK():-
---> It leaves a gap in the sequence of ranking in the
event of tie.
DENSE_RANK():-
---> It doesn't leave a gap in the sequence of ranking
in the event of tie.

EX:-
empno ename RANK DENSE_RANK
101 AAA 1 1
102 BBB 2 2
102 BBB 2 2
102 BBB 2 2
103 CCC -->5 --> 3
103 CCC 5 3
104 DDD -->7 --> 4

What is degenerate dimension table?

999

---

Explain why denormalization is promoted in universe designing?

959

---

What are data modeling and data mining?

1081

---

What is VLDB?

1051

---

What is the difference between a primary and secondary actor in use case modeling?

1064

---

Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1020

---

What are the advantages of raid 1, 1/0, and

978

---

What a static and local variable?

1076

---

Ist the schema that a data warehouse system can implements.

936

---

Can you state some of the innovations throughout history?

978

---

Can you pass sql queries in filter transformation?

1011

---

What is the difference between star and snowflake schemas?

1212

---

Why should we use data ware housing and how can you extract data for analysis with example?

994

---

What are the types of partitioning?

1049

---

Explain what is the extension of file to save template?

973

---