topic Re: Can I full load a single DataMart Fact Table? in Qlik Compose

Can I full load a single DataMart Fact Table?

RonFusionHSLLC — Fri, 14 Mar 2025 20:49:07 GMT

We had some server issues, and looks like some of our fact tables did not update properly (they are pointing to the wrong dim records). Is there a way to re-process just the fact table to get the fact table to point to the correct dim records? I'd prefer not to have to do a full DM load - but I know that is an option.

Compose on Sql Server November 2023 release

ron

Re: Can I full load a single DataMart Fact Table?

TimGarrod — Wed, 21 Aug 2024 20:56:37 GMT

Hi Ron - check out the mark object for reload CLI in help - https://help.qlik.com/en-US/compose/November2023/Content/ComposeDWDL/Main/DW/Data%20Marts/reload-datamart.htm

This allows you to mark a specific object to be reloaded. Marking a fact table will only force a reload of the given fact table.
Note this will reload the entire fact table - but will allow you to select the fact to reload.

Re: Can I full load a single DataMart Fact Table?

RonFusionHSLLC — Thu, 22 Aug 2024 13:24:13 GMT

Thanks for the heads up...I forgot about this option.

ron