Logical data model data types generated from the Cognos-to-dimensional-logical data model transformation

The Cognos-to-dimensional-logical data model transformation generates logical data model data types from Cognos model data types.
The following table shows the correspondence between Cognos primitive types and dimensional-logical data model types.
Table 1. Cognos data model to dimensional-logical data model data type mappings
Cognos primitive types Logical data model types that the transformation generates
  • binary
  • binaryLength16
BINARY(length)
bit BINARY(length)
  • blob
  • blobArray
BLOB(length)
boolean BOOLEAN
  • character
  • characterLength16
  • characterLength32
CHAR(length)
date DATE
dateTime TIMESTAMP
decimal DECIMAL(precision,scale)
  • float
  • float32
FLOAT(precision)
float64 DOUBLE
int16 SHORT
int32 INTEGER
int64 LONG
intervalYM INTERVAL
nChar CHAR(length)
numeric DECIMAL(precision,scale)
nVarChar VARCHAR(length)
textBlob CLOB(length)
  • time
  • timeTZ
TIME
timeInterval INTERVAL
timeStampTZ TIMESTAMP
varBit VARBINARY(length)
  • databaseKey
  • unknown
  • unsupported
n/a

Feedback