Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is bteq script in teradata?
What is meant by a dispatcher?
What is the purpose of using case expression in teradata?
What is the function of parser component in teradata?
Why managing the data is important?
What are the scenarios in which full table scans occurs?
In general, how do you optimze any sql in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
Define views in teradata with syntax.
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is difference between user and database in teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
What are the different softwares used with their functions in teradata?
What are the primary characteristics of the Teradata.
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
