Review the following replication considerations for Greenplum targets:
When replicating LOB data to Greenplum targets, the Applier and InitialSync truncate the LOB data to the size that is specified in the
global.lob_truncation_size
runtime parameter.
By default, when InitialSync uses the native load utility to load source data to the target, the utility loads null values and empty strings as null values. Set the
global.nz_pg_empty_strings_as_null
runtime parameter to 0 to differentiate between empty strings and null values.