I'm in the middle of trying to figure this out - Incorta table w/ multiple key columns, some of which may be NULL on some rows. Do I need to assign ( IfNull ) fake values to these for Incorta to recognize them as part of a key?
e.g. Think Order Header and Lines - if the lines are deleted but the header still exists I want a snapshot of the header w/ no lines.
To clarify - the header/line join is in the source SQL. I hadn't anticipated a use case where a header is created ( which automatically creates a line ) but then the line is deleted.
I think populating the NULLs w/ a value will create a "no rows row" which should be acceptable.