Custom Truncate

Utility for ensuring Data Quality

Business Problem

  • Solution that can have measures to stop deleting the target data when there is no data at source.

Solution

  • Truncates the destination only when there is data at source table.
  • Ensure Data Quality. Allow only legitimate data to flow in the system.

Why is the solution unique

  • One Process being used by multiple modules/ SPs/ EYLS

Features/BP diagram of the solution

  • Quality measure to stop deleting the target data when there is no data at source.




Proof Points

  • Process is being used by USBSO team as a data quality check.