You might encounter this issue when you reset a data set that you create on an Oracle test data warehouse to a Microsoft SQL Server database.
The issue also occurs when source data contains characters that the PowerCenter Integration Service cannot process. Null values replace the characters in the target. The workflow fails if the target column is a non null column.
You can configure a project to provide default values to use for empty string values in non null target columns. All plans that you run from the project use the default values. You can edit the values as required.
From the Project Configuration tab on the
Administrator | Preferences
page, add a default field to the project configuration. You must have the Manage Preferences privilege to create default fields.
Use the following name and format:
The field appears on the
dialog box. You can enter values that you want to use in place of empty string values in non null columns.
A workflow fails if the non null column in the target is a Unique column.