Archives of the TeradataForum

Message Posted: Fri, 21 Jul 2000 @ 16:57:15 GMT

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

I've been a DBA and implementation lead on many Teradata warehouses (including some very BIG and some very SMALL systems). I have some Oracle experience and work with Oracle DBA's very often. Oracle almost always co-exists, often sources, and sometimes hosts target data marts. DBA's who aren't inordinately biased towards one or the other usually end up saying that the workload on them is much less with Teradata and performance is better. But it is highly dependant on the data model implemented and the application.

Oracle is very strong in OLTP - Teradata isn't. They're both competent, but one clearly excels. The same is true in decision support with 3NF models and queries with joins. They're both competent, but one clearly excels. Both do OK in a Star Schema, but realize the limitations of the schema - if you don't put it in, you can't get it out (as a dimension that is). You can't conveniently add or subtract dimensions or add subject areas.

Hope this helps.

Sam Sterling
www.ssterling.com

Admin Comment: When last tried, the URL in this Post no longer functioned.

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