what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 5881 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 pmrep command?
What is data modeling and data mining?
what is the difference between cubes and package in cognos
how many steps are there in etl process?
What are the different Lookup methods used in Informatica?
how do u identify the changed records in operational data?
How to increase performance without changing anything in mapping.( In prod)
What are dimensions?
State the differences between shortcut and reusable transformation
what is the meant by Normalization and de-normalization?
What are the types of Data Warehouse applications?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
how do u set partition points in the mapping?
What is staging area referring to?
flat filevalidation in informatica
