What is the maximum table name & column name length and the Max number of columns allowed?

Max table name length – 127 characters
Maximun column name length - 127 characters.
Max no of columns – 1000

different scenarios in Replication in SAP HANA

What are the different scenarios in Replication?
Load – Starts the initial load of replication of data from the source system. It is a one-time process.
Replicate – Actual phase of replication. Database triggers and different logging tables for every table is created in SLT.
Stop – Stops any replication currently in process. Database triggers are aborted.
Suspend – Table replication is paused. Database trigger will not be deleted and changes will be filled in logging tables.
Resume – Restarts the replication for a suspended table.

Schema in data warehouse - SAP HANA

Database uses relational model to store data. However, Data Warehouse use Schemas that join dimensions and fact tables to meet business logic. There are three types of Schemas used in a Data Warehouse −

1. Star Schema

2. Snowflakes Schema

3. Galaxy Schema

SAP HANA LIVE

SAP HANA Live (previously known as SHAF – SAP HANA Analytic Foundation) is solution for real-time reporting on HANA. ... SAP HANA Live provides SAP-delivered content (similar in concept like SAP BW content), in form of SAP HANA calculation views for real-time operational reporting.

It is a separate package that comes with predefined SAP HANA content across the SAP Business Suite.

What does SAP HANA Live provides?

SAP HANA Live provides SAP-delivered content (similar in concept like SAP BW content), in form of SAP HANA calculation views for real-time operational reporting.  The calculation views spans across majority of ECC modules (FI, CO, MM, PP, SD, PS, CRM, GTS, AM and GRC).

The content is represented as a VDM - virtual data model, which is based on the transactional and master data tables of the SAP Business Suite.

Different engines in SAP HANA

The different engines available in HANA Database to process models execution. They are,

1. Join Engine
2. OLAP Engine
3. Calculation Engine
4. ROW Engine
5. SQL Engine

What is the difference between catalog and content?

In HANA Studio every HANA system has two main sub-nodes, Catalog and Content.

Catalog:

• The Catalog represents SAP HANA’s data dictionary, i. e. all data structures, tables, and data which can be used. 
• All the physical tables and views can be found under the Catalog node. 

Content:

• The Content represents the design-time repository which holds all information of data models created with the Modeler. 
• Physically these models are stored in database tables which are also visible under Catalog. The Models are organized in Packages. The Contents node just provides a different view on the same physical data. 
• The created Column Views are always located in schema _SYS_BIC, their metadata in schema _SYS_BI.

List the different compression techniques in HANA?

1. RUN LENGTH ENCODING
2. CLUSTER ENCODING
3. DICTIONARY ENCODING