thanks for the reply, but scd type 2 won't help me as the change will normally be in the fact table.

for example the use updates an order to change the price 3 days after it was created.