LinkedIn
Copied!

Table of Contents

Deleting the records from the FACT table

Version:

Only available versions of this content are shown in the dropdown

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

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

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.