This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.
Summary
Many inactive CI's under K_CI table
Error
If we run DLC against this table, we can observe hundreds of CIs. Can we delete?
Cause
OBR Collects dimension data from Topology source and also loads such data in K_CI table
Fix
We can use below query:
select CI_UID,Display_Name,dsi_key_id from K_CI where display_name is null or name is null
We can filter them and check are they rea based on CI_UID and Creation date. If they are very old we can delete with DLC and inactive option as they will not impact Fact data in OBR