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
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
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
Dear Readers, In this article, we will learn about BLOCK LEVEL COMPRESSION IN TERADATA. Block Level Compression (BLC) is a space reduction technique in Teradata. It has been introduced in 13.10 and is used to apply compression to all the permanent data blocks in a… Read More
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
NOPI( NO PRIMARY INDEX) table in Teradata Dear Readers, In this article, we will learn about No Primary key indexes in Teradata As the name suggests, No primary index table means there is no primary index defined on Teradata table. This feature has been introduced… Read More
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 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
Dear Readers, How all of you are doing well & safe. Today I was reading some documents referring new DB enhancements in Oracle 18C & found we can do Oracle’s AUDIT table exports using datapump. I remember some of links in Oracle MOS/Docs mentioning, EXPDP… Read More
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 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
Dear Readers, In this article, we will learn about MULTILOAD UTILITY in Teradata MultiLoad can load multiple tables at a time and it can also perform different types of tasks such as INSERT, DELETE, UPDATE and UPSERT. It can load up to 5 tables at… Read More
PRIMARY INDEX IN TERADATA Dear Readers, In this article, we will learn about PRIMARY INDEX IN TERADATA In Teradata, Parallelism is one of the main feature. As we already know AMPs are the one which perform the actual operation of the query. So, to maintain… Read More
ETL and Data Transfer utilities in Teradata Dear Readers, In this article, we will learn about ETL and Data Transfer utilities in Teradata Teradata database has various techniques to load the data into tables. Below are the 5 commonly used load utilities. Fast load Multi… Read More
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 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 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
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 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
Hi Readers, In this article,we will see Migrating Table data from MySQL to Oracle Using SQL* LOADER. Step 1 : Connect to Mysql DB and create a table [root@ip-172-31-46-32 ~]# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or… Read More
