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
- 47408 Views
- Bank Of America, Wipro, I also Faced
- E-Mail Answers
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 spool space?
Can we collect statistics on table level?
What is the command in bteq to check for session settings ?
How to run a query in teradata?
What is the meaning of Caching in Teradata?
How is MLOAD Client System restarted after execution?
Mention a few of the ETL tools that come under Teradata.
Why do you get spool space errors? How do trouble-shoot them?
how do you manage the production space. what are the proactive methods you can take ?
Explain vproc in teradata?
What are the string manipulation operators and functions associated with teradata?
If RDBMS is halted what will you do ?
Explain the term 'row' related to relational database management system?
What are different table types used in teradata?
In Teradata, what is the significance of UPSERT command?
