why should we go Teradata over Oracle,what is the main
differences?
Answers were Sorted based on User's Feedback
Answer / talk2sreenivas@gmail.com
In Teradata Architechture is shared nothing.
It supports unconditional parallelism.
supports terabytes of data.
we can load bulk data into tables with less time.
| Is This Answer Correct ? | 17 Yes | 0 No |
Answer / my name is manguni
Teradata is generally preferred for data warehousing
because of its "shared nothing" architecture and
unconditional parallelism. Perfect for OLAP and handling
very huge amount of data.
--- By manguni manikam from saidapet.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / yuvaevergreen
>>>Adding to the above, the distribution of data in disks would be uniform where as in oracle i hope it is range distribution.
>>> Similarly, for reporting purpose, the data can be exported in a very fast manner using utilities compared to oracle.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / anay reddy
Apart from that data distribution and retrival will be
parallel
| Is This Answer Correct ? | 1 Yes | 0 No |
What is meant by Teradata Gateway?
What are the 5 phases in a multiload utility?
Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.
What do you mean by tpt in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
what is identity columns in TD?
Describe the set operators in teradata.
What's the difference between timestamp (0) and timestamp (6)?
How to run the Teradata jobs in unix environment ???
In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M