How to handle early arriving Facts or late arriving Dimensions

There are three common options available to handle early arriving Facts or late arriving Dimensions.

Option 1:

Do not load fact - Redirect/ignore the records

Option 2:

Load Fact with an unknown key (0 or -1), but make sure that dimension already have unknown member

Option 3:

Load Fact with create inferred member - Inferred members exist when a fact table references dimension members that are not yet loaded. When data for the inferred member is loaded, you can update the existing record rather than create a new one.

Cheers!
Uma