Hi All,

I have created a new data mart past 7 years data in .XFC file format with size of 20GB. Now, I have deleted 2 years data from .XFC data mart. Still .XFC data mart shows same size.

Is it any other way to reduce .XFC size when we deleting records from Datamart.

Thanks,

This message has been edited. Last edited by: FP Mod Chuck,

I suspect you will need to rebuild the XFC (assumed to be XFOCUS) file.

This is via the REBUILD command