Handling Numeric/Decimal Datatype Precision Differences between Aster and Informatica - 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
In Aster, the maximum supported precision for numerica/decimal data types is unlimited. In Informatica it is 28.

When exporting or importing to an Aster field with precision greater than 28, you must specify a precision of 28 or lower to avoid a this error: Requested conversion is not supported.

A number with precision greater than 28 will lose its precision during the transfer.

  1. In the PowerCenter Designer, use Source Analyzer or Target Designer to specify a precision of 28 or lower for a field that had precision greater than 28 in Aster database.