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(length) |
| bit |
BINARY(length) |
|
|
BLOB(length) |
| boolean |
BOOLEAN |
- character
- characterLength16
- characterLength32
|
CHAR(length) |
| date |
DATE |
| dateTime |
TIMESTAMP |
| decimal |
DECIMAL(precision,scale) |
|
|
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 |
| timeInterval |
INTERVAL |
| timeStampTZ |
TIMESTAMP |
| varBit |
VARBINARY(length) |
- databaseKey
- unknown
- unsupported
|
n/a |