Teradata

BTEQ utility is a powerful utility in Teradata that can be used in both batch and interactive mode. It can be used to run any DDL statement, DML statement, create…

FastExport utility is used to export data from Teradata tables into flat files. It can also generate the data in report format. Data can be extracted from one or more…

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…

FastLoad utility is used to load data into empty tables. Since it does not use transient journals, data can be loaded quickly. It doesn't load duplicate rows even if the…

This chapter discusses the procedure of performance tuning in Teradata. Explain The first step in performance tuning is the use of EXPLAIN on your query. EXPLAIN plan gives the details…

This chapter discussed the various strategies of user management in Teradata. Users A user is created using CREATE USER command. In Teradata, a user is also similar to a database.…

This chapter discusses the features available for data protection in Teradata. Transient Journal Teradata uses Transient Journal to protect data from transaction failures. Whenever any transactions are run, Transient journal…

OLAP functions are similar to aggregate functions except that the aggregate functions will return only one value whereas the OLAP function will provide the individual rows in addition to the…

Partitioned Primary Index (PPI) is an indexing mechanism that is useful in improving the performance of certain queries. When rows are inserted into a table, they are stored in an…

This chapter discusses the various JOIN strategies available in Teradata. Join Methods Teradata uses different join methods to perform join operations. Some of the commonly used Join methods are −…