hello there. i am running a job that compares latest extract with the before extract and captures new, updated and deleted records in a dataset each. change mode is set to "explicit keys, all values".
everything works beautifully except for the fact that "excluded as value" column on the dataset that has deleted records has null values in it. all the other columns have values except for this particular column. what is strange is that this column DOES NOT have null values in other datasets (such as updates dataset or the inserts dataset).
i have runtime column propagation on throughout the job and all the metadata is read from the schema files.
