Answer Posted / sathish arichandran

Each Dimension table has been split into more than one
dimension and connected with centralized fact table. It has
bigger size than star schema. Dimensions are sliced
deeply with the business requirements.

But it is tough to understandable since it has more tables

Can you brief about the Data warehouse project you worked on?

2379

---

What are the various file formats involved in reportnet?

982

---

Explain swot analysis?

1167

---

What is a full backup?

964

---

What is defined as partial backup?

1076

---

What are the possible data marts in retail sales?

998

---

What is static and local variable?

1036

---

Explain when do we analyze the tables? How do we do it?

1000

---

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

1019

---

What are the different types of fact tables used in data warehousing?

995

---

Explain the difference between data ware house & data mart?

958

---

Why is dimensional normalization not required?

1089

---

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

983

---

List down some of the real time data-warehousing tools?

974

---

Explain what are the advantages and disadvantages of reporting directly against the database?

1003

---