Symptom
Have created a table and used it in a Data Flow as a target table. Not all columns are mapped with the source table and the expectation is to add data manually for the unmapped column. Every time when the Dataflow is run the unmapped column gets filled with NULL values and the manually entered value gets replaced with NULL for the unmapped column.
Environment
SAP Datasphere
Reproducing the Issue
- Create a dataflow with a target table with one added column that does not match the source table
- Run the dataflow so the target table gets populated with values
- Add values for the unmapped column using data editor
- Run the dataflow and the manually added value gets replaced with NULL
Resolution
This is a documented restriction in Datasphere. New runs of the dataflow will insert null values to unmapped columns. This is documented under Process Source/Target Changes in the Data Flow Editor.
See Also
Keywords
Dataflow, NULL, unmapped column, datasphere , KBA , DS-DI-DF , Data Flows , Problem