Converting Between In-Memory and Extended Tables in SAP HANA Dynamic Tiering
Tutorials that teach this
- Tutorial Migrate Records in Related Tables Using Stored Procedures
- Tutorial Selectively Move Data Between In-Memory and Extended Tables
- Tutorial Creating a Calculation View from the Union of In-Memory and Extended Tables
- Tutorial Convert Between an In-Memory Table and an Extended Table
- Tutorial Converting Between an In-Memory Table and an Extended Table
Prerequisites
- Concept Creating and Removing Extended Storage in SAP HANA Dynamic Tiering
- Concept SAP HANA Information Views (Attribute, Analytic, Calculation)
- Concept Schema Creation and Management in SAP HANA
- Concept Using the SQL Console in SAP HANA Cloud Central
- Concept Creating SQL Views in SAP HANA
- Concept Data Aging with SAP HANA Dynamic Tiering (Hot/Cold Data Management)
- Concept SAP HANA Studio Administration Console
- Concept Database Transaction Isolation Levels (READ COMMITTED, REPEATABLE READ, SERIALIZABLE)
- Concept Converting SAP HANA Information Models to Calculation Views via Mass Copy
- Concept SQL Commands for Extended Storage (CREATE/DROP EXTENDED STORAGE)
- Concept SQL INSERT INTO ... SELECT Statement
- Concept Defining Column Tables with SQL in SAP HANA
- Concept Foreign Key Constraints and Extended Table Conversion in SAP HANA Dynamic Tiering
- Concept SAP Web IDE for SAP HANA
- Concept SAP HANA Development Perspective in SAP HANA Studio
Concepts that build on this
- Concept SQL INSERT INTO ... SELECT Statement
- Concept Using the SQL Console in SAP HANA Cloud Central
- Concept Creating SQLScript Stored Procedures in SAP HANA
- Concept Data Aging with SAP HANA Dynamic Tiering (Hot/Cold Data Management)
- Concept Creating SQL Views in SAP HANA
- Concept Foreign Key Constraints and Extended Table Conversion in SAP HANA Dynamic Tiering
- Concept Union Node in SAP HANA Calculation Views
- Concept SAP HANA Multi-Store Tables (In-Memory + Extended Storage)