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