Answer Posted / nethaji

We use star schema when the query involves few joins and for
better performance.here data is denormalized.
Snow-flake schema is an extension of star where the
dimensions are divided into hierarchy of dimensions.eg: time
dimension.
time->year->month->day
For complex joins we go for snow-flake.performance is little
bit slower due to no. of joins.Here data is normalized.

How to generate the cubes in framework manager?

1042

---

How much data hold in one universe.

994

---

What is the difference between power center & power mart?

983

---

Database in use is oracle?

1053

---

What is edw?

1196

---

Briefly state different between data ware house & data mart?

1050

---

How to export mappings to the production environment?

909

---

What should I have in mind when building olap solution from scratch?

983

---

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

911

---

what are the different views that are considered when building an object-oriented software system?

1032

---

Explain what is the difference between olap and datawarehosue?

1092

---

What is a real-time data warehouse?

998

---

Difference between PowerPlay transformer and power play reports?

2517

---

Difference between e-r modeling and dimentional modeling?

936

---

I need a good brd and uc template?

1087

---