Answer Posted / uzval_vee

hai

In my case ETL tool is used to extract data from diffrent
sources,and make the data consistent and transformed to DWH.
olap tools are nothing but a DWH.

What is the extension of file to save template?

1008

---

I have two universes created by two difference database can we join them in designer & report level? How

984

---

Suppose we want to display zero when null values coming to report how can we do that?

926

---

What is a core dimension?

1069

---

Explain differences between star and snowflake schemas?

1157

---

Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1029

---

How can we schedule the graph in unix?

1000

---

Explain what is the difference between stop and abort?

1045

---

What is factless fact tables?

1212

---

What is cubes?

1074

---

Why fact table is in a normal form?

991

---

what are different storage options supported by oracle ?

2092

---

What are the difference between snow flake and star schema?

1006

---

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?

1060

---

Explain what is the difference between power center & power mart?

999

---