What is data validation strategies for data mart v?

1093

---

Explain what are fact, dimension, and measure?

993

---

Explain why denormalization is promoted in universe designing?

961

---

What is latest version of power center / power mart?

1060

---

What is partitioning? What are the types of partitioning?

1171

---

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

933

---

What is an er diagram?

1053

---

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

930

---

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

1020

---

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

932

---

What is the difference between ods and oltp?

1026

---

Explain difference between view and materialized view?

965

---

How to design file watch jobs?

974

---

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?

934

---