Answer Posted / manasi r

Warehouse is used for high level data analysis purpose.It
is used for predictions, timeseries analysis, financial
analysis , what -if simulations etc. Basically it is used
for better decision making.

OLTP is NOT used for analysis purpose.
It is used for transaction and data processing.
Its basically used for storing day-to-day transactions that
take place in an organisation.
The main focus of OLTP is easy and fast inputing of data,
while the main focus in data warehouse is easy retrieval of
data.
OLTP doesnt store historical data.(this is the reason why
it cant be used for analysis)
DW stores historical data.

Explain in detail abt measure objects? And what is the use of it? How to create it?

938

---

What is called data cleaning?

1134

---

Explain dimension table ?

920

---

How can we schedule the graph in unix?

931

---

What needs to be done while starting the database?

1045

---

List down some of the real time data-warehousing tools?

912

---

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

898

---

What is hybrid slowly changing dimension?

985

---

Explain why are oltp database designs not generally a good idea for a data warehouse?

972

---

What is the data type of the surrogate key?

926

---

Explain grouped cross tab?

2562

---

What is the main difference between star and snowflake star schema? Which one is better and why?

974

---

Explain functional dependency?

1029

---

Explain the difference between oltp and olap?

1053

---

Explain the structure of cold fusion?

990

---