General
The recommended method of creating a Fact table is to create a Stage table and use this as the source for the fact table.
If you try to create a Fact table directly from a Data Store or Normalised table you may see a procedure compile error and the resulting code contains a line like: ...