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
- 50592 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
Can you fastexport a field, which is primary key by putting equality on that key?
Explain the term 'database' related to relational database management system?
What is a node in teradata? Explain
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What are normalization, first normal form, second normal form and third normal form?
What are the different methods ot loading a dimension table? A fact table etc?
What is stored procedure in teradata?
How does hashing happens in teradata?
What does Amp contain and what are all the operations that it performs?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What do you mean by parsing?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is the multi-insert?
Explain the new features of teradata?
