Links may not function; however, this content may be relevant to outdated versions of the product.
Deleting the records from the FACT table in Microsoft SQL Server databases
Perform this procedure to delete records from the FACT table in a Microsoft SQL Server database.
- Connect to the source database.
- Execute the following script:
DELETE FROM <SOURCE_DATABASE>.<SOURCE_SCHEMA>.PR_DATA_IH_FACT WHERE PXOUTCOMETIME < CONVERT(data_type(length),expression,style);
Example
DELETE FROM <SOURCE_DATABASE>.<SOURCE_SCHEMA>.PR_DATA_IH_FACT WHERE PXOUTCOMETIME < CONVERT(DATETIME,'30-06-15 10:34:09 PM',5);
data_type
expression
style
Previous topic Merging the dimension records in Microsoft SQL Server databases Next topic Applying interaction history scripts in Db2 Database Software