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 |
BLOG PAGES
- Home
- Manual Testing Materials
- Manual Testing Interview Q & A
- ISTQB
- UNIX /Linux
- SQL
- Agile Methodology
- Selenium with Java
- Selenium with Python
- Automation Testing Materials
- API Testing
- Cypress Tutorials
- ETL Testing Documents
- Big Data Hadoop
- Mock Interviews
- Resume Templates
- YouTube Videos
- Online Training
OLAP vs OLTP
Popular Posts
- How To Explain Project In Interview Freshers and Experienced
- Selenium Frequently Asked Questions & Answers Part-6
- API/Webservices Testing using RestAssured (Part 1)
- Manual Testing Interview Questions & Answers-PART1
- How to use HashMap in Selenium WebDriver
- Java Programs for Selenium
- Manual & Automation Testing Free Video Tutorials | YouTube Playlists
- ETL Test Scenarios and Test Cases
- Python Interview Questions and Answers Part-1