Mapping Limitations - Aster Client

Teradata Aster® Client Guide

Product
Aster Client
Release Number
7.00
Published
May 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
hki1475000360386.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
B700-2005
lifecycle
previous
Product Category
Software

The Aster Database data type timestamptz does not support dates before 1883-11-18 in the US time zone. If this is an issue, map timestamptz to the DT_WSTR SSIS data type.

Mapping the Aster Database data type double to DT_WSTR with a special value of 1.7976931348623157E+308 is not supported. The SSIS Connector only transfers 14 digits after the floating point. In this case, the value of DT_WSTR is the string “1.79769313486232E+308”, which is the rounded value of 1.7976931348623157E+308.

You cannot map the Aster Database data type bytea with length > 8000 bytes to DT_BYTES. If you configure error handling, a truncation error is generated.

Mapping the Aster Database data type decimal to DT_NUMERIC might result in precision loss, because DT_NUMERIC is not an absolute accurate data type. For example, 9999999999999999999999999999.99 maps to 10000000000000000000000000000.00.