Archives of the TeradataForum
Message Posted: Mon, 08 Jan 2001 @ 20:50:03 GMT
One of the many strengths of Teradata is the ability to build a database that largely resembles the logical model. Tweaks/indexes and super-clever DBAs to make it work in an acceptable fashion are the norm in the DB2/Oracle world, but not Teradata. Denormalisation is the curse of a lesser DBMS, imho. Stick with your normalised model for all the classic reasons and you won't go far wrong. A healthy dose of business analysis on top of that basic approach is the tried-and-tested Teradata approach. Those that talk about flattening tables and star schemas are usually out of their depth and not used to dealing with terabyte databases.
Whilst I'm on...can anyone recall the discussion a few weeks ago about Oracle-Teradata migration tools, or did I imagine that? Not content with moving what was allegedly Europe's largest Oracle db onto Teradata, I'm doing it again for another client. We will use the traditional extract/ship/load method unless someone points us at a tool (not ETI et al).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|