Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the difference between transaction database and data warehouse databases?

April 26, 2017Data database databases difference transaction warehouse

0

Posted

What is the difference between transaction database and data warehouse databases?

1 Answer

0

Posted

Submitted by: opbang Transaction Database Vs DataWarehouse Database- 1. Transaction Database is Relational Database with the normalised table, whereas DataWarehouse is with denormalised Table. 2. Transaction Database is highly volatile… Designed to maintain transaction of the business Where DataWarehouse is non volatile.. with periodic updates. 3. Transaction Database is OLTP… Datawarehouse … is for analysis… 4. Transaction Database is functional data… DataWarehouse database Data is subject oriented.