When working on a multidimensional design, every fact table within scope should be handled with care. In an ideal world, each low-level fact table represents the metrics related to a business event.

Updating fact rows inside a star schema set of tables is never a best practice. Even so, some organizations travel down this path.