What is data validation strategies for data mart v?

1092

---

Explain what are fact, dimension, and measure?

992

---

Explain why denormalization is promoted in universe designing?

961

---

What is latest version of power center / power mart?

1058

---

What is partitioning? What are the types of partitioning?

1169

---

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

933

---

What is an er diagram?

1052

---

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

927

---

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

1019

---

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

924

---

What is the difference between ods and oltp?

1022

---

Explain difference between view and materialized view?

962

---

How to design file watch jobs?

973

---

What is the differences between star and snowflake schemas?

1067

---

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

931

---