Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 04 Jun 2007 @ 12:27:09 GMT


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


Subj:   Re: Teradata / Essbase fact tables
 
From:   Barry Hull

I would recommend option 2, combined with compressing the fact columns on NULL or whatever the default value is. I assume that in some cases, some of the fact elements will not exist.

The first reason that I would go with this option is the space savings that you will achieve vs. restating the keys in addition to the row overhead that you will encounter with option 1. Secondly, whenever I see option 1 used in design, I usually see reports that are more closely aligned with option 2. So, in the end, the queries end up denormalizing the data to get it to look like option 2.


That's my two cents.

Barry

Barry Hull
Orange Diamond Consulting, LLC



     
  <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: 28 Jun 2020