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 is upsert statement in teradata?
What do you mean by caching in teradata?
What are the design features involved in teradata?
Explain the term 'database' related to relational database management system?
What are the available primary index types?
How to select first n records in teradata?
Explain teradata architecture in detail with a diagram.
What are the different softwares used with their functions in teradata?
What is the syntax for case when statement?
How can we check the version of Teradata that we are using currently?
Can you connect multiload from ab initio?
What are the different table types supported by teradata?
What is the multi-insert?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What are the functions of a Parser?