seen from China
seen from Brazil
seen from China
seen from United Kingdom
seen from Sweden
seen from Thailand
seen from Germany
seen from China
seen from United Kingdom
seen from China
seen from Sweden
seen from United States
seen from Sweden
seen from Sweden
seen from Ecuador
seen from Australia
seen from Italy
seen from Germany
seen from United States
seen from Sweden
Teradata Stage Table Design
Teradata Stage Table Design
Even though stage tables are only temporary objects, holding intermediate data, a decent table design can make the difference between a good performing load and a load which is proceeding at a snail’s pace. The additional efforts is paying off soon.
The correct choice of data types and sizes is important. At the end of the day it’s the amount of bytes which have to be pushed into Teradata which…
View On WordPress
Teradata Compression with the DWHPRO TITHONIZER
Teradata Compression with the DWHPRO TITHONIZER
Do you work in an environment where a compression tool is installed that works to your satisfaction?
If not, I assume you are probably not very pleased with having to walk your way through the databases, table by table, to find out what to compress on which column. Typically, this is time-consuming, fatiguing and subject to momentary human judgment to some extent.
Every reevaluation is costly…
View On WordPress
Teradata Compression: Should you bother?
Teradata Compression: Should you bother?
The Teradata DBMS has always supported compression in a (growing) number of forms. Version 5.0 introduced Multi-Value Compression (MVC), version 13.10 introduced Algorithmic (ALC) and Block Level (BLC) compression and version 14.0 introduced multiple automatic compression options for Columnar tables.
All of these can produce disk space and associated performance savings; however implementing…
View On WordPress
Teradata Multivalue Compression - a Quick Approach
Teradata Multivalue Compression – a Quick Approach
Whenever you have to analyse a huge Teradata table regarding multivalue compression, this is a costly operation. Usually, it involves the counting of the number of distinct values per table column. This can be resource and time intense.
Luckily, with Teradata 14.10 we have another method available which is much cheaper from a resource point of view but less comprising:
SHOW STATISTICS VALUES…
View On WordPress
