We have some fact tables . Now the business needs a view (fact table left outer joined to some other dimesion tables )which they can use for historical trend analysis. So even though the fact tables are partitioned , the partitioned column will not be used in filters when querying the view since they need to look at the trends. So basically no partition elimination and they will possibly be running full table scans.
Can teradata view handle this type of trend reporting? If not, what are the options in this scenario?