How to remove Data from SALES_DATA tables before 24 months
Hello Everyone,
We have old data in Sales_Data tables which is more than 24 months. We do not use historic data more than 24 months to forecast.
What is the easiest way to remove data earlier than 24 months?
1) Is there a std feature to clear historic data based upon a date?
2) Is there any custom script we can use to remove historic data ? I want to be aware of any known pitfalls after we remove data from Sales_data table.
Thanks for your time.
rgds
Aqil