BW offers ready out-of-the-box components to meet the general challenges when ETL-ing, staging, exploring and broadcasting structured and integrated information in a BI solution. OLTP as it name suggests OnLine Transaction Processing System, where as BW is related to analysis and decision making...
OLAP systems organize data in a multidimensional model that is suitable for decision support. OLAP is the analytical counterpart of OLTP, or Online Transactional Processing. SAP's BW is an OLAP system Get help for your SAP BW problems SAP Business Warehouse Certification, Interview Questions and Co...
So, you can differentiate between OLAP and OLTP systems based on their Oracle parameters settings also. Check SAP Note 830576 - Parameter recommendations for Oracle 10g. We keep different parameters for both systems. If you have ECC it will be a OLTP system and if u have OLAP it will be O...