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.

Difference between cold fusion mx 6 and cold fusion mx 7?

842

---

How would you write a left join statement to return a result set of movie.title�s and director.name�s?

1029

---

what are the other factors of the database on which the loading performance depend?

1912

---

What is core dimension?

1066

---

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

975

---

What is a Decision Tree Algorithm?

5012

---

Can you state some of the innovations throughout history?

984

---

How to load the time dimension?

1014

---

Tell me what is full load & incremental or refresh load?

952

---

What are cluster analysis in data warehousing?

1113

---

What is bi?

1100

---

What is the metadata extension?

1002

---

Which are the olap tools available that are supported by oracle?

937

---

What is the very basic difference between data warehouse and operational databases?

971

---

How can you communicate with web server (apache or iis) from coldfusion?

1120

---