Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
RonFusionHSLLC
Creator II
Creator II

Can I full load a single DataMart Fact Table?

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

Labels (2)
1 Solution

Accepted Solutions
TimGarrod
Employee
Employee

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-dat...

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.

View solution in original post

2 Replies
TimGarrod
Employee
Employee

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-dat...

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.
RonFusionHSLLC
Creator II
Creator II
Author

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

 

ron