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?
Change Capture
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.