Many inactive CI's under K_CI table

  • KM03687018
  • 28-Jul-2020
  • 28-Jul-2020

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.


Many inactive CI's under K_CI table


If we run DLC against this table, we can observe hundreds of CIs. Can we delete?


OBR Collects dimension data from Topology source and also loads such data in K_CI table


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