BTEQ EXPORT:- Record/DATA mode- This is set by .EXPORT DATA. In this mode data will be written to flat file in native format i.e. INTEGER data is written as a 4 bytes binary field. It cannot be read and understood … Read more »
BTEQ, stands for Basic Teradata Query and pronounced as bee-teeek, is a general purpose, command driven utility that enables user to interact with one or more Teradata Database Systems. Teradata BTEQ allows to perform below tasks- Can submit SQL in … Read more »
Algorithmic Compression (ALC), a new compression technique introduced in Teradata 13.10, is mainly designed for compressing data with well-know columns. Teradata provides a few built in ALC algorithms. For example, to compress Unicode column data Teradata provided TransUnicodeToUTF8 algorithm. Apart … Read more »
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 table. The compression rate can be achieved by this … Read more »
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 reducing the cost of storing data. One … Read more »
RAID is a technology that uses multiple physical disk drives to protect data from a single disk failure. The purpose of RAID is to ensure that at the time of failure, there should be one copy of data which should … Read more »
Whenever the user executes any query, Teradata creates different execution plans and chooses the best plan to execute the SQL query. These execution plans are based on the statistics collected on the tables used within the SQL query. The information … Read more »
Explain plan is the step-by-step English translation of a query plan generated by the parsing engine. Explain plan can give you a clear picture the way optimizer will execute a query. It is a good practice to analyze the explain … Read more »
Teradata Volatile tables act like a normal Teradata table but are volatile in nature. What does that mean? The Volatile tables in Teradata are created by the user and used only for the duration they are logged into the Teradata … Read more »
Teradata provides the flexibility to use three types of temporary table which helps user to accomplish their work more easily. This kind of table is temporary to the database that means tables are not going to store permanently in the … Read more »