I started working in a new company, where my manager has this proposal regarding one of the tables.
The proposed changes are as follows:
Because there are many data, we should have one table for each year. For example, FactCost_2020, FactCost_2021, … and because older tables are not under load and are processed once a day, there is no need to participate in case reports and ETLs.
Each year has about 200,000,000 records
The disadvantage of this method is that some places like QlikView and tabular cubes have to change, that is, there are many changes, but every year.
Is this a logical way?