Selective Data Migration Between In-Memory and Extended Storage
Tutorials that teach this
- TutorialMigrate Records in Related Tables Using Stored Procedure
- TutorialMigrate Records in Related Tables Using Stored Procedures
- TutorialSelectively Move Data Between In-Memory and Extended Tables
- TutorialView Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
- TutorialCreate Multi-Store Tables
- TutorialSeeing Calculation View Results
- TutorialConvert Between an In-Memory Table and an Extended Table
- TutorialMulti-Store Tables
- TutorialConverting Between an In-Memory Table and an Extended Table
Prerequisites
- ConceptSAP HANA Stored Procedure Creation and Execution
- ConceptSAP HANA Database Administration
- ConceptSQL JOIN Operations (INNER JOIN)
- ConceptSQL DDL and DML Statements (CREATE, INSERT, DROP)
- ConceptSAP HANA SQL API Usage
- ConceptDatabase Transaction Isolation Levels
- ConceptSQL Nested Queries and Subqueries
- ConceptForeign Key Constraints and Referential Integrity
- ConceptAuto Commit and Manual Transaction Control in SQL
- ConceptSQL Querying Fundamentals (SELECT, WHERE, GROUP BY, ORDER BY)
- ConceptSAP HANA In-Memory Relational Database
- ConceptSAP HANA Dynamic Tiering (Extended Tables)
- ConceptHANA Column Store and Row Store Tables