Consider the following rules and guidelines for PostgreSQL data types:
The default precision for reading bytea,
JSONB, string, or text data types is 32,000. If you configure a mapping to read
data with the
bytea, JSONB, string, or text data types whose precision is more than 32,000,
you need to manually increase the precision of these data types in the mapping
accordingly.
Citext data type is considered as
case-sensitive text in the following scenarios:
When you configure a cached
lookup and you define the lookup condition for the column of the Citext
data type.
When you configure an
Expression transformation for a column of the Citext data type.
ASK INFAPreview
