Re: Oracle to Teradata

Comments in-line.

mikeeria_at_interia.pl wrote:
> Hi,
>
> Plans are to expand an existing warehouse. Oracle will be too small
> therefore the new datawarehouse will be built on
> Teradata.

I highly doubt that. Where'd you get this information? The Teradata salesman?

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/storeman.htm#sthref1584

I doubt you are really building a database larger than 40 exabyte.

But if you are please let me know as I will come work on the project for free just for the experience. And I have 3 years of Teradata too (5100M V2R1-V2R3). ;-)

> Is it possible to move a Oracle data warehouse snowflake model to
> Teradata which I think uses a different approach (more normalized )??

In Oracle you shouldn't have a snowflake either if you properly designed your warehouse. And by move what do you mean? The reality is going to look something like: Export the data as ASCII ... reload.

> In other words, is it worth to reuse the Oracle model which already
> exists and is working on the Teradata database
>
> or
>
> Forget all what was created before with Oracle and restart with
> Teradata's models and methodology ? and recreate all ETL, reports
> etc...
>
> I will appreciate any information on this subject
>
>
> regards
> Beton

I'm still trying to figure out why you spent so much money on a box that won't give you anything you couldn't get with Oracle. Reloading that much data should take you ages. So it would seem that any restructuring is likely a luxury: Can you afford it?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)