| |
GeekInterview.com > Interview Questions > Data Warehousing
| Print | |
Question: Data Warehouse as Transaction Database
Answer: Can a Data Warehouse also be used for Transaction Database? If Yes Why, If No Why not? |
| June 06, 2009 00:22:56 |
#1 |
| SQLGal |
Member Since: October 2008 Total Comments: 6 |
RE: Data Warehouse as Transaction Database
|
| No, a data warehouse cannot by definition be used as a transaction database. A data warehouse is "read only" data that does not change once it has been loaded and used for information purposes. Data is loaded into a data warehouse and then cannot be modified. It does not change. A transactional database processes data one transaction at a time. It is a very dynamic and lively system. Data can be modified and changed in a transactional system. |
| |
Back To Question | |
