What is the difference between a W/H and an OLTP application?
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.
Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
Difference between cold fusion 5 and cold fusion mx 6?
What is meta data and system catalog?
what is parallel query?
What should I have in mind when building olap solution from scratch?
What is called dimensional modelling?
What is edw?
Define Data Warehousing?
What are fundamental stages of data warehousing?
Start a batches with in a batch?
What are aggregate tables and aggregate fact tables?
What is a cube in data warehousing concept?
Explain the data type of the surrogate key?
What is real-time datawarehousing?
What are the different types of schemas used in data warehousing?
Explain grouped cross tab?