What is data validation strategies for data mart v?

1179

---

Explain what are fact, dimension, and measure?

1049

---

Explain why denormalization is promoted in universe designing?

1002

---

What is latest version of power center / power mart?

1147

---

What is partitioning? What are the types of partitioning?

1238

---

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

973

---

What is an er diagram?

1104

---

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

969

---

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

1079

---

Explain why should you put your data warehouse on a different system than your oltp system?

991

---

What is the difference between ods and oltp?

1083

---

Explain difference between view and materialized view?

1023

---

How to design file watch jobs?

1023

---

What is the differences between star and snowflake schemas?

1121

---

What are the various methods of getting incremental records or delta records from the source systems?

997

---