How Does Incorta treat NULLs for KEY columns

[RADSr]

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.   

[amit_kothari]

Yes, please add a NVL or coalesce condition for that key. Also in your example to get header with no lines just enable the 'Show empty groups' in a aggregated insight.

[RADSr]

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.

Thank you!