Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a W/H and an OLTP application?
- 5 Answers
- 11741 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
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
Can you state some of the innovations throughout history?
How to test report in reportnet?
Explain what are components of report studio?
Explain what are the methodologies of data warehousing?
What needs to be done while starting the database?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
what are the other factors of the database on which the loading performance depend?
What is meant by metadata in context of a data warehouse?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
What is the very basic difference between data warehouse and operational databases?
What is surrogate key? Explain with examples.
Explain what is real time data-warehousing?
What are the advantages of raid 1, 1/0, and
What are universe requirements?
