Articles

ACCESS RIGHTS IN TERADATA

 ACCESS RIGHTS IN TERADATA Hi  Readers, This article contains types of access(Privileges)  in Teradata. What is a privilege ? A database privilege is a permission to access or to manipulate a database object or data. Privileges are sometimes called access rights, permissions, or authorizations. Privileges… Read More

Partitioned Primary Index in Teradata

Dear Readers, In this article, we will learn about Partitioned Primary Index in teradata. Partitioned Primary Index A primary index can be either Partitioned OR Non-partitioned Primary indexes for join and hash indexes can also either be hash- or value-ordered, while primary indexes for all… Read More

COMPRESSION IN TERADATA

Dear Readers, In this article, we will learn about COMPRESSION IN TERADATA. We all know that now-a-days how many transactions are happening per day in this digital world. To store those data in data warehouse we need more storage disk. So everyone is looking for… Read More

PERMANENT JOURNAL

PERMANENT JOURNAL Dear Readers, In this article, we will learn about PERMANENT JOURNAL IN TERADATA The permanent journal in Teradata provides the capability to capture the snapshot of  permanent tables before and after applying changes using DML statements like insert, delete and update. Copies of… Read More

SECONDARY INDEX IN TERADATA

Dear Readers, In this article, we will learn about SECONDARY INDEX IN TERADATA A table can contain only one primary index. More often, you will come across scenarios where the table contains other columns, using which the data is frequently accessed. Teradata will perform full… Read More

CHECK TABLE IN TERADATA

CHECK TABLE IN TERADATA The CheckTable utility is a diagnostic tool that finds inconsistencies and data corruption in data structures, such as table headers, row identifiers, and indexes (including geospatial). CheckTable offers several levels of data checking. Higher-level checks are generally more thorough than lower-level… Read More

SQL SERVER Articles

SQL SERVER Articles Dear Readers, Please check below articles to get good knowledge on SQL SERVER. SNO DESCRIPTION ARTICLE LINK 1 SQL Server – Issue to view Alwayson Health Events https://www.ktexperts.com/sql-server-issue-to-view-alwayson-health-events/ 2 Script to copy one particular database role from one SQL server to another… Read More

TERADATA DBA Articles

TERADATA DBA Articles Dear Readers, Please check below articles to get good knowledge on TERADATA DBA. SNO DESCRIPTION ARTICLE LINK 1 Teradata dbscontrol parameters and system level tunables https://www.ktexperts.com/multiload-utility-in-teradata/ 2 Teradata Secondary Indexes in Teradata https://www.ktexperts.com/primary-index-in-teradata/ 1 MULTILOAD UTILITY in Teradata https://www.ktexperts.com/multiload-utility-in-teradata/ 2 PRIMARY INDEX… Read More

FAST EXPORT UTILITY IN TERADATA

FAST EXPORT UTILITY IN TERADATA FastExport is a command-driven utility that uses multiple sessions to quickly transfer large amounts of data from tables and views of Teradata Database to a client-based application. Data can be exported from any table or view where the SELECT privilege… Read More

Teradata DBA – USEFUL SQLs

Teradata DBA – USEFUL SQLs This article contains all the basic queries needed by a DBA to collect different kind of information from the database. Table of Contents 1.Disk Space Total disk space Percent of disk space in use Percent of disk space free Percent… Read More

Types of Locks in Teradata

Types of Locks in Teradata  Locks are used to protect data integrity when multiple users try to access or change the same data simultaneously. This can be achieved by locking the target data. Example : Assuming user_1 is updating a table, so if user_2 tries… Read More

TSET

Dear Readers, In this article, we will learn about Tset. What is TSET ? TSET stands for Teradata System Emulation Tool. It is a tool that is used to collect a set of support files that help in troubleshooting issues. It allows you to emulate… Read More

How to collect TSET

How to collect TSET This article will provide instructions on exporting data and collecting TSET step-by-step (export & pack) Note : Please make sure the version of TSET installed on your PC or laptop is compatible with the currently running TDBMS version. TSET is required… Read More

More Latest News »