Skip to Content
0
Former Member
May 27, 2008 at 05:09 AM

Clear Fact Table

27 Views

Dear all

I want to clear my fact table for some reasons and I found that the Clear package from DM doesn't work. The values are still there.

After investigating, I found that all the values have been moved to tblFactXXX table by Full Optimization Application.

The questions are:

1. After running optimization app, we cannot clear the data anymore ?

2. If it is, can I just simply delete the records from tblFactXXX table to remove the values ?

Thank you.

Halomoan