Cognos model data types generated from the dimensional-physical data model-to-Cognos model transformation

The dimensional-physical data model-to-Cognos model transformation generates Cognos model data types from physical data model types.
The data type mapping performs the following steps to map the data types between models:
  • Physical data model-to-logical data model mapping, which is vendor-specific and defined in data type maps
  • Logical data model to Cognos model data mapping
During the transformation process, dimensional-physical data models are converted to logical data models. The following table shows the correspondence between logical data model types and Cognos model primitive types that result from the transformation.
Table 1. Logical data model to Cognos model data type mappings
Logical data model types Cognos primitive types that the transformation generates
BINARY(length) binary
BLOB(length) blob
BOOLEAN boolean
CHAR character
CHAR(length) characterLength32
CLOB(length) textBlob
CURRENCY(precision,scale) decimal
DATE date
DECIMAL(precision,scale) decimal
DOUBLE float64
FLOAT(precision) float32
INTEGER int32
INTERVAL timeInterval
LONG int32
SHORT int16
TIME time
TIMESTAMP dateTime
VARBINARY(length) varBit
VARCHAR(length)
  • characterLength16
  • characterLength32

Feedback