Answer Posted / prodyot sarkar

A snowflake schema is a variation on the star schema, in which very large dimension tables are normalized into multiple tables. Dimensions with hierarchies can be decomposed into a snowflake structure when you want to avoid joins to big dimension tables when you are using an aggregate of the fact table. For example, if you have brand information that you want to separate out from a product dimension table, you can create a brand snowflake that consists of a single row for each brand and that contains significantly fewer rows than the product dimension table.

Advantages of Using the Snowflake Schema
i)in some cases may improve performance because smaller tables are joined,
ii)is easier to maintain
iii)increases flexibility.

Disadvantages of Using the Snowflake Schema
i)increases the number of tables an end-user must work with
ii)makes the queries much more difficult to create because more tables need to be joined.

What is cost benefit analysis (cba)?

1001

---

Difference between e-r modeling and dimentional modeling?

941

---

What are the different types of segments?

999

---

What are the steps of implementing data warehousing?

1050

---

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

966

---

How are models actually derived?

2011

---

What are the steps to build the datawarehouse?

1043

---

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2139

---

Explain me what is vldb?

938

---

What is core dimension?

1067

---

What is the function of etl when used in data warehousing?

964

---

What is the difference between olap and datawarehosue?

963

---

what type of raid setup would you put your tx logs?

956

---

I need a good brd and uc template?

1093

---

Explain which columns go to the fact table and which columns go the dimension table?

932

---