Answer Posted / yuvaevergreen
Compression helps in enhanced storage, improved response
time, CPU savings.
Select Currentperm from DBC.tablesize where
tablename='tablename'; Using the permsize, we can know about
the percentage space saved.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is teradata? Also, list out some of the primary characteristics of teradata.
How do you define Teradata?
Explain PDE.
Which is faster fastload or multiload?
What is TPD?
Highlight the differences between Primary Key and Primary Index.
What is the basic syntax for teradata select statement?
What is meant by a dispatcher?
What are tpump utility limitations?
What is teradata? What are some primary characteristics of teradata?
Name the five phases that come under MultiLoad Utility.
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?
How many sessions of MAX is PE capable of handling at a particular time?
Explain amp in teradata?
What is upsert statement in teradata?