How feasible is Teradata?

[TDKID]

Hi,
We are looking for a database for analytical purpose, can any one help me out in getting the info how feasible in Teradata, we are currently considering different RDBMS suitable for our system. I have got some inputs of the things from Teradata website and PDFs.

Can any one tell me how much time it takes for ETL for a table, even though its impossible to say how big the data is or what transformation the table needs.. Can I get a approximate figure.
How long it take for a table
which dosen’t have much calculations to be carried during calculation.
which has complex calculations to be carried during calculation.
This is irrespective of which load utility I use may be fastload, mload, or tpump

TIA

 

[dirklieske]

I am not certain of your question:

IF you are asking:
How long does it take for data to be loaded into a Teradata Database from a file? Then it really depends on the ratio of hardware to your filesize and how well you write your ETL. So my answer is it depends, however I will say the strait loading of a file is as fast or faster than Oracle, and once the data is in the DB is blows DB like oracle away on selects. However Teradata is a warehouseing database, I would still strongly consider other DB's if you are looking at OLTP processing.

If you are asking:
How hard/difficult is it to write an ETL to Load data from a file?
Again it depends on the complexity of the ETL required. Are you simply loading row for row and column for column? If so you can write a fastload or multiload script in a relatively short period of time 1 to 5 days depending on skill level and required documentation and testing. However, like anything it depends I would imagine the sky is the limit on the complexity that could exist in an ETL process.