1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE?
2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?
Answer Posted / praveen
Addition to above answers
Lets Think there are 50 records to be inserted into the table and each record will take 1 sec. If we are doing in oracle or Teradata (with 1 amp) It will take 50 secs. But due to parallelism we can increase the amps. let us assume we have 5 amps. So, now the amount of work is distributed between 5 Amps and now it will take only 10 sec's. Whatever the database we are using time efficient should be imp. So, Teradata is used in many DWH projects.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are the newly developed features of Teradata?
Differentiate primary key and partition key?
How to eliminate product joins in a teradata sql query?
What are the scenarios in which full table scans occurs?
How can we check the version of Teradata that we are using currently?
Describe the set operators in teradata.
What is meant by a Channel Driver?
What is the difference between teradata and basic rdbms?
Name the five phases that come under MultiLoad Utility.
How will you solve the problem that occurs during update?
What are the various indexes in teradata?
What are the 5 phases in a multiload utility?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What is upsert statement in teradata?
What do you mean by teradata sql assistant?