Recreating the Landing Area metadata cache
To improve performance when reading from the Landing Area or from the Data Warehouse tables, Compose for Data Warehouses caches the metadata from both the Landing Area and the Data Warehouse tables. However, synchronization issues may sometimes occur if the metadata structure of the Landing Area or the Data Warehouse tables is altered outside of the Compose for Data Warehouses project.
If you aware of external changes to the metadata or if you notice any data synchronization anomalies, Compose for Data Warehouses enables you to recreate the metadata cache as required.
There are two ways of clearing the Landing Zone metadata cache.
- Open the Source Table/View Selection - <Landing_Area_Name> window as described in Discovering the Source Database or Landing Area.
- Click the Clear Cache button located below the Show internal Qlik tables option.
Click the Manage button at the bottom left of the Data Warehouse panel.
The Manage ETL Sets window opens.
- In the Mappings tab, click Clear Landing Cache.
For information on clearing the Storage Zone cache, see Recreating the data warehouse metadata cache.