11. Types of Schemas?
- System schema
- User schema
- SLT schema
- Schema generated by SDA/SDS
12. What is Columnar Compression?
Column store compresses data using methods like dictionary, run-length, cluster compression.
13. What are table partitions?
Splitting a big table into smaller chunks to improve performance and parallel processing.
14. Types of partitioning?
- Range
- Hash
- Round-robin
- Composite
15. What is Calculation View?
SAP HANA modeling object combining tables, joins, logic for analytics; built with nodes like Join, Union, Aggregation.
16. Difference between Attribute View, Analytic View, Calculation View?
Earlier: Attribute (dimension), Analytic (fact + joins).
Now: Calculation View replaces all (XS Advanced).
17. What is SQLScript?
SAP HANA’s extended SQL language for complex logic, loops, cursors, calculation engines.
18. What is a Stored Procedure?
Reusable SQLScript logic stored in the database executed by applications.
19. What is CDS (Core Data Services)?
Semantic data modeling layer used in S/4HANA; executed on HANA DB.
20. Difference between CDS View vs Calculation View?
- CDS: Created in ABAP layer; integrates with S/4HANA.
- Calculation View: Created in HANA DB; more flexibility in modeling and performance tuning.