Compare Data Warehouse database and OLTP database. | OLAP Questions

Data Warehouse is used for business measures cannot be used to cater real time business needs of the organizationand is optimized for lot of data, unpredictable queries. On the other hand, OLTP database is for real time business operations that are used for a common set of transactions. Data warehouse does not require any validation of data. OLTP database requires validation of data.

This entry was posted in OLAP Interview Questions. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *