1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE?
2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?
- 6 Answers
- 47407 Views
- Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Teradata is RDBMS and Oracle is Object RDBMS. Teradata has
been mainly designed to OLAP whereas Oracle is for OLTP.
Both can be used for OLTP and OLAP. But, Teradata is mainly
used for DWH because of its parallelism. Even a simple table
with less no of rows is also distributed equally among the
amps. This gives TD an edge over Oracle, when it comes to
DWH. Oracle is very well suited for transaction processing
because of its object rdbms nature.
| Is This Answer Correct ? | 32 Yes | 6 No |
Post New Answer View All Answers
What are differences between teradata and ansi session modes in teradata?
What do you mean by ttu in teradata?
How does hashing happens in teradata?
How can you track login parameters of users in teradata?
How to identify ppi columns?
What are the available primary index types in teradata.
How to load specific no.of records using bteq, or fastload,or multiload
What is real time and near real time data warehousing?
what are the day to day activities of teradata DBA ?
What are the enhanced features in teradata v2r5 and v2r6?
Highlight a few of the important components of Teradata?
How do you do backup and recovery in teradata?
What is spool space? Why do you get spool space errors?
What are the joins in teradata and how many types of joins are there in teradata?
What is the use of having index on table?
