 |
 |
Archives of the TeradataForum
Message Posted: Mon, 08 Jan 2001 @ 20:50:03 GMT
| Subj: | | Re: Technical Data Modelling |
| |
| From: | | Paul Johnson |
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).
Cheers,
Paul Johnson
UK
| |
