Reload Data Mart Dimension

[Al_gar]

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.

[adpaiks]

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.

[Nanda_Ravindra · Accepted solution]

@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

[aj96]

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.