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 mappingsLogical 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
|