what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 5891 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sanchari chowdhury
Records in a OLTP database can be updated or modified or
deleted. However,the same is not possible in DW.
OLTP database is used for transactional purposes e.g. day-
to-day sales or finance and DW is used for analytical
decisions.DW is mainly used for business decisions to
ensure stability of the organisation by curbing the
possible failures. This is possible because it contains the
historical or the archived data for analysis.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / parvar
The main difference between oltp and dw are,
Oltp dw
1 current data historical data
2 normalized data de-normalized data
3 small database large database
4 application-oriented subject-oriented
5 row by row loading bulk loading the data
The data
| Is This Answer Correct ? | 0 Yes | 0 No |
Two different admin users created for repository are________and_________.
What is data cleaning?
What is fact? What are the types of facts?
What is partitioning? Explain different types of partitioning?
How many steps etl contains explain with example?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
How to delete data which is not in source table?
0 Answers IBM, Saama Tech, Wipro,
what make u disappointmnets in u r career
When do we go for the tools in the market?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
What is initial load and what is full load?
what is the use of structures?how many nodes can u create in a structure?
Teradata 
