Null Foreign Key

[kkraemer]

So is this an exceptable practice in the Data Warehouse?

I have a situation where an employee is terminated and the reporting relationships no longer exists.

[BoxesAndLines]

The relationship existed when the fact row was created. Do you want to alter history?

[kkraemer]

There is no requirement to maintain historic reporting relationships

[BoxesAndLines]

The I offer that you do not need a data warehouse.

[BrianJarrett]

I'm not familiar with your warehouse but to me this sounds like it could be solved pretty easily by flagging your employee dimension record. The simplest solution being an 'active' boolean flag. That could be filtered at the report level to exclude anyone not currently active (termed). It could also be a term date that gets filtered out on the report.

I'd need more requirements in order to design something more elegant.