The tool allows for matching on non-physical primary key values. It is usually best to include an index to make the match more efficient, but the logic will work either way. Right now, the "on clause" that matches the target to the source table doesn't account for null values because it uses the "=" operator and not the "IS NULL" clause.
The tool allows for matching on non-physical primary key values. It is usually best to include an index to make the match more efficient, but the logic will work either way. Right now, the "on clause" that matches the target to the source table doesn't account for null values because it uses the "=" operator and not the "IS NULL" clause.