What is data validation strategies for data mart v?

1029

---

Explain what are fact, dimension, and measure?

942

---

Explain why denormalization is promoted in universe designing?

919

---

What is latest version of power center / power mart?

1005

---

What is partitioning? What are the types of partitioning?

1094

---

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

890

---

What is an er diagram?

982

---

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

889

---

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

964

---

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

877

---

What is the difference between ods and oltp?

967

---

Explain difference between view and materialized view?

903

---

How to design file watch jobs?

935

---

What is the differences between star and snowflake schemas?

1004

---

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

907

---