Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

SAP HANA and Transformation Datatypes

SAP HANA and Transformation Datatypes

The following table compares SAP HANA datatypes and transformation datatypes:
SAP HANA Datatype
Range
Transformation Datatype
Range
Alphanum
Precision 1 to 127
Nstring
1 to 104,857,600 characters
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
Binary
Used to store bytes of binary data
Binary
1 to 104,857,600 bytes
Blob
Up to 2 GB
Binary
1 to 104,857,600 bytes
Clob
Up to 2 GB
Text
1 to 104,857,600 characters
Date
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
Precision 10, scale 0
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Decimal (precision, scale) or Dec (p, s)
Precision 1 to 34
Decimal
Precision 1 to 28, scale 0 to 28
Double
Specifies a single-precision 64-bit floating-point number
Double
Precision 15
Float
Precision 1 to 53
Double
Precision 15
Integer
-2,147,483,648 to 2,147,483,647
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
NClob
Up to 2 GB
Ntext
1 to 104,857,600 characters
Nvarchar
Precision 1 to 5000
Nstring
1 to 104,857,600 characters
Real
Specifies a single-precision 32-bit floating-point number
Real
Precision 7, scale 0
Seconddate
0001-01-01 00:00:01 to 9999-12-31 24:00:00
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Shorttext
Specifies a variable-length character string, which supports text search and string search features
Nstring
1 to 104,857,600 characters
Smalldecimal
Precision 1 to 16
Decimal
Precision 1 to 28, scale 0 to 28
Smallint
-32,768 to 32,767
Small Integer
Precision 5, scale 0
Text
Specifies a variable-length character string, which supports text search features
Text
1 to 104,857,600 characters
Time
24-hour time period
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Timestamp
0001-01-01 00:00:00.0000000 to 9999-12-31 23:59:59.9999999
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Tinyint
0 to 255
Small Integer
Precision 5, scale 0
Varchar
Precision 1 to 5000
String
1 to 104,857,600 characters
Varbinary
1 to 5000 bytes
Binary
1 to 104,857,600 bytes


Updated July 02, 2020