{"id":52969,"date":"2019-03-31T11:30:50","date_gmt":"2019-03-31T06:00:50","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=52969"},"modified":"2021-12-05T21:45:05","modified_gmt":"2021-12-05T16:15:05","slug":"sap-hana-data-warehousing","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sap-hana-data-warehousing\/","title":{"rendered":"Data Warehousing in SAP HANA – Components, Methods, Working & Benefits"},"content":{"rendered":"

In the last tutorial, we learned about the SAP HANA Information Modeler,<\/strong> now we will understand the concept of data warehousing in SAP HANA. Data warehouses are not new to the world of business intelligence, yet, they are an integral part of SAP HANA\u2019s architecture and conceptual framework.<\/p>\n

Before moving on to details of Data Warehousing in SAP HANA, we will learn the basic concept of data warehousing.<\/p>\n

What is Data Warehousing?<\/h3>\n

A simple answer to this is, Data warehousing is a technique or system that collects transformed data from either or both homogenous and heterogeneous data sources and transfers into a single data store<\/em>. It provides the data to the analytical tools. The data warehouses are known to be the central repositories of a business intelligence system.<\/p>\n

Both real-time and historic (pre-existing) data can set the data warehouses collected from either the enterprise\u2019s operational sources or an external data source. As we know, the traditional databases keep transactional data which is one-dimensional data.<\/p>\n

And, it cannot be used for analytical and reporting purposes, such databases are called OLTP (Online Transactional Processing)<\/strong> database. But the data warehouses are OLAP type databases which provide processed data for analytical operations like data mining, OLAP analysis, reporting etc.<\/p>\n

A data warehouse typically contains metadata, raw data and summary data which is used by analytic tools for reporting, planning, and forecasting.<\/p>\n

Next, in the SAP HANA Data Warehousing tutorial, we will discuss the components of Data Warehouse Architecture.<\/p>\n

Components of Data Warehouse Architecture<\/h3>\n

A typical data warehousing architecture in SAP HANA consists of four parts, data sources, staging zone for ETL processing, data types in warehouse and presentation or data access part<\/strong>.
\n\"Data<\/a><\/p>\n