However, if you use a Netezza connection, you must set the syncNetezzaNullWithPCNull and treatNoDataAsEmptyString custom properties to configure Data Validation to treat null values as nulls. For more information about these custom properties, see the Informatica Knowledge Base article 531184.
If you use an Amazon Redshift v2 connection, Data Validation treats empty strings also as nulls.
When you use a Salesforce connection to compare two tables with identical column names, one table might display null data incorrectly even though it contains data. You can duplicate the Salesforce connection and use a different connection for each source to make sure the data is not mistaken for null. You must avoid using the same Salesforce connection for both tables or sources.