Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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 Hull
Orange Diamond Consulting, LLC

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020