Padding

Use padding (headroom) with aggressive type mappings (num=2, var=1) to accommodate potential increases in the maximum size of values stored in the Oracle database tables. This approach helps avoid reanalyzing the data and regenerating the TimesTen schema if the data changes.

Use the padding field in the -typeMap command-line option to apply a padding factor to aggressive type mapping. The padding field accepts an integer value from 0 (the default) to 1000. This value specifies the percentage increase to apply to the maximum precision or length of the stored values determined during data analysis.

For example, you map a NUMBER column and the data analysis determines that the maximum stored precision is 8 and the maximum stored scale is 2. If you specify a padding factor of 50 (50%), the import process increases these values to 12 and 3, respectively, before performing the type mapping.

Similarly, if the maximum stored value length for a VARCHAR2 column is 100 and you specify a padding factor of 25 (25%), the import process increases the maximum length to 125 before performing the type mapping.