Published May 05, 2017 by
Pavan
| Transaction Database | Data warehouse database |
| Dedicated database available for specific subject area or business application | Integrated from different business applications |
| It does not keep history | It keeps history of data for analyzing past performance |
| It allows user to perform the below DML operations (Select/Insert/Update/Delete) | It allows only Select for end users |
| The main purpose is for using day to day transactions | Purpose is for analysis and reporting |
| Data volume will be less | Data volume is huge |
| Data stored in normalized format | Data stored in de-normalized format |
