What is use of compress in terdata?Explain?

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


Please Help Members By Posting Answers For Below Questions

What are the design features involved in teradata?

798


What is the difference between global temporary tables and volatile temporary tables?

881


What do you mean by teradata intellicloud?

832


While creating table my dba has fallback or no fallback in his ddl. What is that?

936


What is real time and near real time data warehousing?

908


In Teradata, what is the significance of UPSERT command?

860


What is a three-tier data warehouse?

846


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

871


Describe the between keyword in teradata?

842


What are the commands to make a new table, change a table and remove a table in teradata?

898


What type of indexing mechanism do we need to use for a typical data warehouse?

858


What is the basic syntax for teradata select statement?

802


Steps to create a data model?

895


Explain teradata architecture?

872


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1574