Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 18 Oct 2000 @ 11:37:02 GMT

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

Subj:   Re: Star Schema
From:   Steve Bracewell

There are a couple of methods we use. One is an old tried and true NCR solution, not pretty, but effective. By adding a meaningless column to the dimension tables and using syntax like below, you can 'force' the product join of the smaller tables.

AND (T.Meaningless_column = P.meaningless_column
OR T.meaningless_column <> P.meaningless_column)
AND (T.meaningless_column = G.meaningless_column
OR T.Meaningless_column <> G.Meaningless_column)

We have also had great success using derived tables to fill out the key and join to the fact table.

Lastly, per the documentation in NCR manuals (and our own testing), we do not collect statistics on the primary indexes of tables with > 1000 rows/amp. Your mileage may vary.

  <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