Skip to Content
0
Former Member
May 27, 2009 at 12:22 AM

Disadvantages of letting FACTFINANCE table grow bigger day by day?

47 Views

Hi All,

Please share your inputs on the Disadvantages and Advantages of letting FACTFINANCE table grow bigger day by day.

As far as i know there's no theoretical limit to the number of records.

If there is any solution or process followed to keep only actively used data records in FACTFINANCE and smart way in dealing with very rarely used data (Historical data).

Please suggest/comment it will greatly help us!

Regards,

Rajesh Muppala.