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

1033

---

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

951

---

What is the difference between ods and oltp?

1044

---

Explain difference between view and materialized view?

977

---

How to design file watch jobs?

987

---

What is the differences between star and snowflake schemas?

1086

---

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

948

---

Explain which columns go to the fact table and which columns go the dimension table?

942

---

Explain me what is vldb?

943

---

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

979

---

Explain the difference between keylokup and joiner?

914

---

Explain what are the various reporting tools in the market?

998

---

Explain what is analytical or analytic mean?

1034

---

Explain how are the dimension tables designed?

1073

---

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

973

---