InterviewSolution
| 1. |
What Is Schema In Sap Hana? |
|
Answer» There are 3 types of schemas: User Defined Schema : These are created by user (DBA or System Administrator SLT Derived Schema : When SLT is configured, it CREATES schema in HANA system. All the tables replicated into HANA system are contained in this schema System Defined Schema : These schemas are DELIVERED with the SAP HANA database and contain HANA system information. There are system schemas like _SYS_BIC, _SYS_BI, _SYS_REPO,_SYS_STATISTICS etc. A database schema is a way to logically group objects such as tables, views, stored procedures etc. There are 3 types of schemas: User Defined Schema : These are created by user (DBA or System Administrator SLT Derived Schema : When SLT is configured, it creates schema in HANA system. All the tables replicated into HANA system are contained in this schema System Defined Schema : These schemas are delivered with the SAP HANA database and contain HANA system information. There are system schemas like _SYS_BIC, _SYS_BI, _SYS_REPO,_SYS_STATISTICS etc. A database schema is a way to logically group objects such as tables, views, stored procedures etc. |
|