handling cases in fact table

Hello All,

I would like to know the best way and if possible automatic formula to handle the case : late arriving facts ?
Notice that I am not using an etl tool, only via stored procedure in pl/sql.

Thanks a lot for your help!

Usually the issue is late arriving dimensions. What is the issue with late arriving facts?

Yes, indeed the case is late arriving dimensions.
How this case can be solved with an SCD type 2 dim ?

Before you update your fact table, identify those business keys for which dimension rows do not yet exist, and create new dimension rows with each business key. When the dimension update arrives you can update the dimension table. Given that you've mentioned SCD2, you might want to think about special logic for the first update of a row that was created in this manner.