Answer / azhar

It stands for OnLine Analytical Processing.It is used for
analysis and decision making.It contains past and
historical data.Data is is non volatile.It is used to
generate Investigation Reports.

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

0 Answers  

---

What are the primary ways to store data in OLAP?

3 Answers  

---

if source contain 10records how you identify header and footer

2 Answers   Polaris,

---

How does data mining and data warehousing work together?

2 Answers  

---

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

0 Answers  

---

---

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

0 Answers  

---

5.Explain ODS ?

3 Answers   HCL,

---

What are components of report studio?

0 Answers  

---

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

0 Answers  

---

What is the difference between view materialized view and view?

0 Answers  

---

What is the use of tabular model, tabular sql, tabular reference in real time application?

0 Answers  

---

What are the types of partitioning?

0 Answers  

---