Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sat!sh
Compression is used to Minimize the table size, for example
when the table size is increasing anonymously We can use
Compression to reduce the size of the table
Conditions:
1.Compression can be declared at the time of table creation
2.We can compress up to 256 column values(not columns)
3.We can't compress variable length fields
(vartext,varchar..)
Explanation for 2 condition:
create table tab1
(
:
:
Order_type char(25) compress ('air','sea','road')
:
)
in the above example order type have 3 fields, one should
be selected by the user, so one of the field will repeat
for every order, like these column values we can use
compress statement because these are repeating for entire
table, like these column values TD supports 256 col
generally NCR people will provides ready made scripts for
these type of compressions
----
Hi friends got any best ans share with us :)
| Is This Answer Correct ? | 18 Yes | 3 No |
Post New Answer View All Answers
Define views in teradata with syntax.
What is the purpose of joins in teradata and what are the available join types?
What do you mean by fastexport in teradata?
What is the primary index in teradata?
What are the joins in teradata and how many types of joins are there in teradata?
How to Extract data from multiple legacy systems?
What are the scenarios in which full table scans occurs?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Explain fastload in teradata?
Highlight all the modes that are present under Confidence Level.
Highlight a few of the important components of Teradata?
Write a program to show the parser component used in teradata?
how many modules are there in telecome domain?how to explain the architecture?
Is multi insert ansi standard?
Describe primary index in teradata?
