Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a W/H and an OLTP application?
- 5 Answers
- 11673 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
Why is business intelligence (bi) important in data warehousing?
Explain what are the possible data marts in retail sales?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
Ist the schema that a data warehouse system can implements.
what are the different views that are considered when building an object-oriented software system?
What is a full backup?
Explain hybrid slowly changing dimension?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
How much data hold in one universe.
What are the various methods of getting incremental records or delta records from the source systems?
How to get the first 100 rows from the flat file into the target?
How to improve session performance in aggregator transformation?
Explain about core dimension, balanced dimension, and dirty dimension?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What are the difference between snow flake and star schema?
