Which means in dimensional table, if it is type2, it gets a new set of PK with every update. Thus, comes with the need of remapping the fact table's FK to that new FK.
Okay, I'm lost here. Why would you have to remap the PK/FK relationship if you entered a new record in the dimension table to the fact table? The value of the PK has changed, not the PK/FK relationship.
😎