Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 7432 Views
- I also Faced
- E-Mail Answers
Answer Posted / murthy
The main deference between them is
OLTP:used to store current transaction data not large
historical data(ex:bank ATM)
DWH:
used to store historical data aruond 3-6 years.
apart this include the standara differences
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what is an ETL or ETT? And what are the different types?
What is etl process? How many steps etl contains?
Explain about round-robi?
What is data cleaning?
What is partitioning? Explain about round-robin, hash partitioning.
What is Data Vault???
dimension object created in oracle can be imported in designer?how?
what is the use of server manager?
Can there be sub steps of etl steps?
what are the reports developed in sap bw project and what is the requirement for developing it?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
What are the modules in Power Mart?
what is the main role of FI on business
what is data modeling?
what is the difference steps for data modeling?
