Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Making a Sum Tbl. from a Detail Tbl. - Rounding
 
From:   Claybourne L. Barrineau

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023