Creating a Fact table from a Data Store or Normalised table

Modified on Mon, 09 Feb 2015 at 09:43 AM

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:


FROM *** Enter source table ***

 

To work around this, rebuild the procedure and check the "Allow Where Clause Editing" box in the fact table procedure build and then type in the FROM clause referencing the Data Store or Normalised table - the procedure will then compile correctly.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article