Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

FAQ: Does Redshift connector processes both empty string & NULL values in IICS CDI?
Answer
Yes, only Redshift V2 connector allows processing both Null values & empty strings from source to target. This functionality is NOT available in the Redshift V1 connector.

In order to process both NULL values & empty strings, one needs to follow the following steps:
  • In the source transformation under advance properties check the property treat NULL as NULL
  • Add the unload property NULL=test
  • In the target set the property 'Require Null value for char and varchar2' = test

More Information
​Thi​s works when both source and target are in Redshift. One needs to make use of Redshift V2 connector.

Applies To
Product: Cloud Data Integration
Problem Type: Configuration; Product Feature
User Type: Developer
Project Phase: Configure; Implement
Product Version:
Database:
Operating System:
Other Software:

Reference

Attachments

Last Modified Date:6/2/2020 3:06 AMID:614787
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)