Blank Data Value in the Source Converts to a Space Character in the Target

Question

A varchar has a blank data value in the source. When replicated to the target, HVR converts it to a space character.

Environment

• HVR 6
• Source: SQL Server
• Target: Snowflake

Answer

To resolve this issue, do the following:

1. Define action TableProperties with parameter TrimWhiteSpace to remove trailing whitespace from varchar.
2. Re-activate the channel.