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
What is a cube in data warehousing concept?
How to drill through from a powerplay cube to reportnet?
What is meta data and system catalog?
How to import vsam files from source to target. Do we need a special plugin?
Is there any rownum object from which we can do this?
What are situations where snowflake schema is better than star schema when the opposite is true?
Explain what are non-additive facts?
What a static and local variable?
Explain the main differences between star and snowflake schema?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
Explain what are components of report studio?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
What are the various tools? Explain name a few?
How to design file watch jobs?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?