Answer Posted / shribhagwan

1 Because More than one dimensions can be shareble for Other
Department

2 The Physical Load will be less.

3 Less Complexity of Fact

Explain about core dimension, balanced dimension, and dirty dimension?

942

---

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

895

---

Describe a data warehouse.

915

---

Can you pass sql queries in filter transformation?

956

---

What are universe requirements?

960

---

What are fundamental stages of data warehousing?

985

---

What is type 2 version dimension?

902

---

How can you import tables from a database?

1000

---

Explain what are the various reporting tools in the market?

914

---

What is the difference between olap and datawarehosue?

896

---

Explain me what are conformed dimensions?

947

---

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

985

---

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

866

---

What needs to be done while starting the database?

1046

---

Compare and contrast aggregates & indexes

3718

---