Tell me what is the difference between OLTP and OLAP?
Submitted by: MuhammadFollowing are the differences between OLTP and OLAP:
OLTP:
Data is from original data source
Simple queries by users
Normalized small database
Fundamental business tasks
OLAP:
Data is from various data sources
Complex queries by system
De-normalized Large Database
Multi-dimensional business tasks
Submitted by: Muhammad
OLTP:
Data is from original data source
Simple queries by users
Normalized small database
Fundamental business tasks
OLAP:
Data is from various data sources
Complex queries by system
De-normalized Large Database
Multi-dimensional business tasks
Submitted by: Muhammad
Read Online Data Warehouse Manager Job Interview Questions And Answers
Top Data Warehouse Manager Questions
| ☺ | Explain what is dimensional modeling? |
| ☺ | Do you know what is VLDB? |
| ☺ | Explain me what is real-time datawarehousing? |
| ☺ | Explain me what is conformed fact? |
| ☺ | Explain me what is meant by Data Analytics? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
