DSXchange

A basic question, I think I know the answer.
When I am comparing fields in a change capture stage and I have a field that can have a null value, will the change capture consider this an edit because you cannot compare null to null?

What happens when you try it?

Does the Change Capture stage even permit nullable fields in the comparison key column(s)? Hint: review the Nulls Position property in the Change Keys group of properties.