Primary mapping maps compatible data types, but there could be range, length, precision, or scale mismatches in the corresponding data values.
For incompatible data types, the Teradata Aster SSIS Connector provides alternative mappings:
- Maps the Aster Database data type to the DT_WSTR or DT_NTEXT SSIS types (Aster Export Source).
- Maps the SSIS types DT_WSTR and DT_NTEXT back to the Aster Database data type (Aster Loader Destination).
When performing alternative mapping, the Teradata Aster SSIS Connector does not change the data values.
This table shows the primary vs. alternative Aster-to-SSIS mappings:
| Aster Data Type | Conditions | Mapping | SSIS Data Type |
|---|---|---|---|
| smallint | Primary | DT_I2 | |
| integer | Primary | DT_I4 | |
| bigint | Primary | DT_I8 | |
| real | Primary | DT_R4 | |
| Alternative | DT_WSTR | ||
| double precision | Primary | DT_R8 | |
| Alternative | DT_WSTR | ||
| numeric [p[, s]] | p => 29 | Primary | DT_WSTR |
| Alternative | DT_WSTR | ||
| p < 29 | Primary | DT_DECIMAL | |
| Alternative | DT_WSTR/DT_R8 | ||
| boolean | Primary | DT_BOOL | |
| Bytea | length > 8000 | Primary | DT_IMAGE |
| length <= 8000 | Primary | DT_BYTES | |
| Character/bit [(n)] Character/bit varying [(n)] |
length > 4000 | Primary | DT_NTEXT |
| length <= 4000 | Primary | DT_WSTR | |
| Date | Primary | DT_DBDATE | |
| Alternative | DT_WSTR | ||
| time [(p)] | Primary | DT_DBTIME2 | |
| timetz [(p)] | Primary | DT_WSTR | |
| timestamp [(p)] | Primary | DT_TIMESTAMP2 | |
| Alternative | DT_WSTR | ||
| timestamptz [(p)] | Primary | DT_DATETIMESTAMPOFFSET | |
| Alternative | DT_WSTR | ||
| serial {local | global} | Primary | DT_I4 | |
| bigserial {local | global} | Primary | DT_I8 | |
| Ip4/Ip4range/uuid/interval | Primary | DT_WSTR | |
This table shows the primary vs. alternative SSIS-to-Aster mappings:
| SSIS Data Type | Mapping | Aster Data Type |
|---|---|---|
| DT_BOOL | Primary | bool |
| DT_BYTES | Primary | bytea |
| DT_DBDATE | Primary | date |
| DT_DBTIME2 | Primary | time without time zone |
| DT_DBTIMESTAMP2 | Primary | timestamp without time zone |
| DT_DBTIMESTAMPOFFSET | Primary | timestamp with time zone |
| DT_DECIMAL | Primary | numeric |
| DT_I2 | Primary | smallint |
| DT_I4 | Primary | integer |
| Alternative | serial | |
| DT_I8 | Primary | bigint |
| Alternative | bigserial | |
| DT_NUMERIC | Primary | numeric |
| DT_R4 | Primary | real |
| DT_R8 | Primary | double precision |
| DT_WSTR | Primary | char varying [(p)] |
| Alternative | Char/bit/varbit [(p)] | |
| Alternative | Ip4/ip4range/uuid/interval | |
| Alternative | timestamp with/without time zone | |
| Alternative | time with/without time zone | |
| Alternative | Real/double/numeric | |
| Alternative | Date | |
| DT_IMAGE | Primary | Bytea |
| DT_NTEXT | Primary | char varying [(p)] |
| Alternative | Char/bit/varbit [(p)] |