Deleting the records from the FACT table
Perform this procedure to delete records from the FACT table.
- Connect to the source database.
- Execute the following script:
DELETE FROM PR_DATA_IH_FACT WHERE PXOUTCOMETIME < TO_DATE(<DATE_STRING>, <DATE_FORMAT_STRING>);
Example
DELETE FROM PR_DATA_IH_FACT WHERE PXOUTCOMETIME < TO_DATE('2015-01-07', 'YYYY-MM-DD')Previous topic Merging the dimension records Next topic Applying interaction history scripts in Microsoft SQL Server