Archives of the TeradataForum
Message Posted: Tue, 20 May 2003 @ 11:12:53 GMT
I was just doing some research about comparison of Teradata, IBM DB2 and Oracle for large size data warehouses. Following are a few queries I would like have some answers for:
* Star schema (denormalized schema) is normally implemented with most of the RDBMS in a warehouse, but Teradata recommends 3rd Normal form for implementation during the warehouse. Why is it so? Does it have any performance impact? Is there any paper presented on the same, that really proves the recommendation?
* Teradata is the master when it comes to warehouses. :-). But is it implemented as an OLTP? What is the impact in implementation/performance as compared to Oracle, DB2, etc.?
* I need a small information. I was trying to do a research on usage/benefits of Informatica, Humming Bird, Data Stage with TPump, mulitload, fastload (as seperate utilities )and Teradata Warehouse Builder. The information about their relative support....
* How do you calculate the amount of total space and nodes required for a given amount of raw disk (for eg. if the Raw data is about 5 TB). Please refer a document for better understanding.
I hope for an early response. Any white paper or presentation would really help. Thanking you in anticipation.
With Warm Regards,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|