topic Re: Reload Data Mart Dimension in Qlik Compose

Reload Data Mart Dimension

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

We have Qlik Compose Aug/2021 version and we're looking the right way to reload a dimension on a data mart. The reason being is because we have some invalid values that were loaded while doing multiple testing and we're just looking to wipe out the dimension and reload with the right data.

Re: Reload Data Mart Dimension

adpaiks — Wed, 05 Oct 2022 07:05:21 GMT

Hello,

What DB are you using as target ?

Have you tried truncating the DIM table? and run your workflow for loading data? it should re-load the mart table.

DataMart also have a setting of load - full rebuild or incremental. If you select full all the data in the mart layer are truncated & reloaded. If you enable this setting and re-generate instructions, it will help you to correct data in the mart layer. You can try this in your lower environment.

Thanks.

Re: Reload Data Mart Dimension

Nanda_Ravindra — Thu, 06 Oct 2022 14:36:52 GMT

@Al_gar The best way to reload the dimension is by using the 2nd option that @adpaiks suggested which is full-rebuild or incremental under the data mart setting .

Please make sure to generate the instructions after you change the setting and then run.

Note: we don't recommend truncating the dimension table out side of compose as it could result in the mismatch between the real table and the sqlite file.

Thanks,

Nanda

Re: Reload Data Mart Dimension

aj96 — Thu, 06 Oct 2022 17:51:04 GMT

You can update the runno update value of the base hub table to next value from dwh runno value.. this would kinda trigger an delete and insert in dm...but if there are alot like 10 million records then probably this isn't a good idea.. rather you can create a new dm and import the needed table and delete the table from old dm if its dim then you can load the data again. The import is not available for fact tables.