How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

1076

---

what type of raid setup would you put your tx logs?

969

---

What is a general purpose scheduling tool?

1132

---

What is the metadata extension?

1011

---

What a static and local variable?

1099

---

Explain when do we analyze the tables? How do we do it?

1012

---

Explain what are the different methods of loading dimension tables?

969

---

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

979

---

Explain what is full load & incremental or refresh load?

999

---

Explain what is the metadata extension?

1056

---

What are the main steps to build the data warehouse?

1129

---

Explain what is the difference between datawarehouse and bi?

988

---

What is scd1 , scd2 , scd3?

1106

---

Explain the difference between oltp and olap?

1135

---

What is a data warehousing?

1178

---