Answer Posted / kvchowdary

degenerate dimension is a data dimension that is stored in
the fact table rather than a separate dimension table. This
eliminates the need to join to a dimension table. You can
use the data in the degenerate dimension to limit or 'slice
and dice' your fact table measure

How to generate the cubes in framework manager?

964

---

What is the difference between olap and oltp?

968

---

How to design file watch jobs?

928

---

Explain why dimenstion tables are denormalized in nature?

875

---

Explain meta data?

956

---

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

895

---

What is drill-through?

925

---

What is data analysis?

898

---

What are the types of partitioning?

978

---

Explain difference between e-r modeling and dimentional modeling?

917

---

Explain Association algorithm in Data mining?

2263

---

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

953

---

What is data validation strategies for data mart v?

1012

---

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

903

---

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1306

---