Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a W/H and an OLTP application?
- 5 Answers
- 11913 Views
- I also Faced
- E-Mail Answers
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
How to know the time taken for particular report execution?
Fact table is in normalized or de-normalized form?
What is Cognos script editor?
How to design file watch jobs?
what is an use case?
What is the data type of the surrogate key?
Is there any rownum object from which we can do this?
What is metadata in context of a datawarehouse?
What is the difference between olap and oltp?
What are the various tools? Explain name a few?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
What is a data profile?
Explain what are the basic needs to join two sources in a source qualifier?
What are the other names given to data warehousing?
In document how to create metrics?
