Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 49998 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 do you mean by caching in teradata?
What are the uses of bynets in multi-node systems?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Differentiate database data and data warehouse data?
What are the various indexes in teradata?
Comment whether bottleneck is an error or not.
How do you set the session mode parameters in bteq?
Mention a few of the ETL tools that come under Teradata.
What are the multiload utility limitations?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What are the advantages of teradata?
What are the joins in teradata?
What does Amp contain and what are all the operations that it performs?
What are the components provided on node?
