Category: HANA

What is star schema ? 2

What is star schema ?

Star schema is the backbone of all data warehouse modelling be it SAP or Oracle . It is a fairly simple concept and is really important for any kind of analysis.   Star Schema...

Introduction Of DeltaMerge in SAP Hana. 0

Introduction Of DeltaMerge in SAP Hana.

In simple terms, DELTA merge is an operation to move the data from WRITE optimized DELTA memory to READ optimized and Compressed MAIN memory. This can be done automatically by HANA using Smart Merge technology or manually using MERGE DETLA OF sql...

Spatial Data Types 0

Spatial Data Types

Spatial data types are used to store values that contain spatial data, such as points, lines, or polygons. The following column types are supported in column tables only: ST_Point, ST_Geometry. The column type ST_Point...

Character String DataTypes 0

Character String DataTypes

The character string data types are used to store values that contain character strings. VARCHAR data types contain ASCII character strings, NVARCHAR are used for storing Unicode character strings. VARCHAR The VARCHAR(n) data type...

Boolean Data Type 0

Boolean Data Type

The BOOLEAN data type stores boolean values . Boolean values are TRUE, FALSE, and UNKNOWN, where UNKNOWN is a synonym of NULL. When the client does not support a boolean type, it returns 1...

Numeric Data Types 1

Numeric Data Types

Numeric data types are used to store numeric information. Each numeric type below has a maximum value and minimum value.A numeric overflow exception is thrown if a value is smaller than the minimum value...

SAP HANA Data Types 0

SAP HANA Data Types

In programming, is a classification that specifies which type of value a variable has and what type of mathematical, relational or logical operations can be applied to it without causing an error. For example ...