Change Capture

[seanc217]

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?

[ray.wurlod]

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.