Archives of the TeradataForum

Message Posted: Fri, 04 Mar 2005 @ 17:56:25 GMT

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

I would argue that denormalised data structures are of benefit in Teradata

A single 'flat' table that contains all product, store, time reference data with statistics collected takes a very small amount of processing time to populate but then is very useful to report queries using Business Intelligence tools such as Business Objects AND any users constructing their own SQL

I would not do this for large 'fact' tables as the overhead is too large

I would recommend building all denormalised tables from third normal form tables on the Data Warehouse and all new data entitiy design and data loading would be carried out using third normal form tables

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