Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 14 Jul 2004 @ 01:01:54 GMT

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

Subj:   Re: Joining to current month
From:   Terry Stover

You could try materializing a single row table with the current period data as part of the ETL process. That allows you to pre-calculate other calendar related data like same day fiscal month, fiscal week, same day last quarter, same day last year etc. I've played with materializing columns to support emulate the windowed aggregate functions like SUM xxxx OVER xxxx. If you are doing a trailing 12 months you just add columns for TTM_BEGIN_DATE and TTM_END_DATE that can be used in a case statement or where clause. Same idea works for quarter to date. If you ever get a situation where the single row current_period table isn't being copied to all amps you have a pretty strong argument for a DR from NCR.

  <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: 23 Jun 2019