Answer Posted / nethaji

There are many dimension tables.
The commonly used are
Confirmed dimension,
Junk dimension,
Degenerated dimension,
Slowly changing dimension,
Rapidly changing dimension

The others are
Virtual dimension,
Regular dimension,
Casual dimension,
Shared dimension,
monster dimension.
These are used on certain condtions.

Explain what is analytical or analytic mean?

958

---

What are the advantages and disadvantages of reporting directly against the database?

929

---

What are the approaches used by optimizer during execution plan?

837

---

Code the tables statement for a single-level (most common) frequency?

881

---

What is normalization, first normal form, second normal form, third normal form?

911

---

Explain what is cost benefit analysis (cba)?

926

---

Explain how are the dimension tables designed?

986

---

Explain degenerate dimension table?

986

---

How to performance tune reports?

1044

---

Explain some of modeling tools available in the market?

898

---

How to create different types of templates?

928

---

How do you create surrogate key using ab initio?

939

---

Difference between cold fusion mx 6 and cold fusion mx 7?

799

---

Code the tables statement to produce a multi-level frequency?

940

---

What is data stream and data adaopter?

1022

---