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

What are vaious etl tools in the market?

938

---

What is operational data store (ods)?

959

---

Explain a linked cube?

907

---

What are modeling tools available in the market?

924

---

Explain meta data?

956

---

How can you communicate with web server (apache or iis) from coldfusion?

1034

---

Difference between e-r modeling and dimentional modeling?

864

---

What is the working process for application.cfm?

982

---

What is "method/1"?

970

---

What are the difference between snow flake and star schema?

941

---

What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

849

---

Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

876

---

Explain difference between data ware house & data mart?

931

---

How would you write a left join statement to return a result set of movie.title�s and director.name�s?

971

---

What is vdl (view definition language) explain?

985

---