DWHPro Insights

stored procedure

Understanding Teradata Load Isolation Most read

Illustration of a network graph with circular nodes joined by lines

Isolation Levels and their Impact on Performance & Concurrency Load isolation provides a defined committed view under its supported rules; it is not a blanket serializability or performance guarantee. Feature support and restrictions must be verified for the target deployment. Teradata provides varying degrees of isolation: In the next chapter, we will describe how these …

Read more

Maximize Your Teradata Compression Potential with DWHPRO TITHONIZER

Illustration of a person in a suit standing beside a database cylinder

Do you work in an environment where a Teradata compression tool is installed that conforms to your satisfaction? If not, I assume you are probably not very pleased with having to walk through the databases, table by table, to find out what to compress on which column. Typically, this is time-consuming, fatiguing, and subject to …

Read more

Benefits of Organizing Stored Procedures into Chapters and Steps

Illustration of a glossy orange database cylinder with data fragments across its surface

I made organizing Stored Procedures into Chapters and Steps a principle. These separation points are marked by comments and variables used in performance and result logging. A step refers to a technical or conceptual task that cannot be further divided without losing the abstraction of Stored Procedures or the main task. Examples of a step …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam