Answer Posted / dhana

There are

1. Multi value Dimension
2. Role playing Dimension
3. Slowly changing Dimension
4. Garbage Dimension or Junk Dimension
5. Fastly Changing Dimension
6. Conformed Dimension

Regards,
Dhana

Explain what is a three tier data warehouse?

980

---

Explain how to generate iqd file from framework manager?

949

---

How we are using this function?

1125

---

Explain the difference between data ware house & data mart?

963

---

Explain can a dimension table contains numeric values?

971

---

What is the differences between star and snowflake schemas?

1070

---

Tell me what is degree of a relation?

1002

---

What is cubes?

1078

---

What is pre-emptive and non-pre-emptive?

977

---

Explain what is the difference between powerplay transformer and power play reports?

1163

---

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

902

---

Explain why dimenstion tables are denormalized in nature?

920

---

Explain about core dimension, balanced dimension, and dirty dimension?

1011

---

What are vaious etl tools in the market?

1007

---

What are the approaches used by optimizer during execution plan?

910

---