Archives of the TeradataForum

Message Posted: Wed, 20 Nov 2002 @ 12:59:49 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Jay,

You could create a view which Unions the 1.5 years of older data from the physical table with a view which materializes the AJI which summarizes the 6 months of current data.

Create View ....
(
Col1,
Col2,
...)
as
(
Select      Col1
,     Col2
,     Col...
From  Summary Fact Table
Where Per   <=    6 months ago

Union

Select      Col1
,     Col2
,     ....
From  AJI View (this view's DML is exactly the same DML as was used to build the AJI)
);

Thanks,

Clay

	<Prev	Next>		<<First	<Prev	Next>	Last>>