Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is use of compress in terdata?Explain?

Answer Posted / oceanblue

Part of the answer by Sat!sh is correct.

However, we can store only one value per column and not 3
(air, sea, road). The compressed value is stored in column
header and is to be used as default of that column unless a
value is present.

e.g.
Dept of Taxes in Washington has a database that tracks all
people working in Washington. Around 99.9% of the tax payers
would have Washington as their state code on their address.
Instead of storing “Washington” in millions of records the
compress will store the value “Washington” in the table
header. Now, a value can be assumed in a row as a default
unless another value exists inside the column.

Is This Answer Correct ?    5 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Highlight all the modes that are present under Confidence Level.

918


How to view every column and the columns contained in indexes in teradata?

982


Explain PDE.

1015


Difference between multiload and tpump?

1043


What does sleep function does in fast load?

1067


what is object level locking ? where do appear this type of locking ?

3448


What are aggregate tables? How do you design them using teradata?

1095


Explain teradata architecture in detail with a diagram.

1053


Why managing the data is important?

959


How will you solve the problem that occurs during update?

987


List out teradata data types?

959


Syntax for case when statement?

1010


If a Node is busy what are the steps you can take to avoid ?

2349


How many sessions of MAX is PE capable of handling at a particular time?

1034


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2361