Kofax Insight Studio > Execution Plans > Remove orphaned rows

Remove orphaned rows

You can add a step to remove orphaned rows. This step removes all rows from tables that have the value=0 in the __IsValidValue column. These rows can be stored in the database only if the data load fails in the middle of loading data. This data is not used in next data loading or for the dashboard components.

  1. In your execution plan, click Add Add icon.
  2. Select Add Remove orphaned rows from the list.
  3. Select the data items to remove.
  4. On the toolbar, click Save Save.