Deleting the records from the FACT table

Perform this procedure to delete records from the FACT table.

  1. Connect to the source database.
  2. Execute the following script: 
    DELETE FROM PR_DATA_IH_FACT WHERE PXOUTCOMETIME < TO_DATE(<DATE_STRING>, <DATE_FORMAT_STRING>);
Example: 

Example 

DELETE FROM PR_DATA_IH_FACT WHERE PXOUTCOMETIME < TO_DATE('2015-01-07', 'YYYY-MM-DD')