Lookup TEST_CATEGORY is a Static List with 19 values which are unique.
Issue is related to table: DWH_LKP_TEST_CATEGORY that's corresponding to this lookup in Data Warehouse.
Instead of only having 19 values the Data Warehouse inserts the entire DWH_LOOKUPS_V in there (7000+ values for all the lookups in the system).
This issue can happen when the attribute and DWH view on Clarity are no longer there and only the lookup value in DWH_META_COLUMNS and DWH LKP table in DWH_META_TABLES are there.
Manually clean up the lookup orphans
To resolve a similar issue please contact Broadcom Support