Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 12 Feb 2001 @ 12:53:10 GMT

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

Subj:   Re: Data Warehouse's Data
From:   Matt Oley


At Connect Austria's data warehouse we have the following load criteria:

CDR's (rated and non-rated) are loaded on a weekly basis for rated and twice-daily for 'raw'/unrated CDR's. The rated data is kept online in one big CDR table for around one year before being shifted to individual monthly tables with no SI's. The unrated data is only kept online for 4 months due to space limitations.

One has over 1 million customers, so the rated CDR table has around 1 billion rows for 14 months data. This is about the limit for sizing on our current configuration, so we are reducing the size to an 8 month history. We will soon be upgrading from a 4 node 5200 (500Mhz processors, 10 AMP's per node) to a 6 node 5250, this will improve performance especially when interrogating CDR records.

We refresh the other data warehouse tables on a daily basis. With new records being added to historical tables and non-historical tables being completely refreshed daily.



Matt Oley
ONE Connect Austria
Data Warehouse


  <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