Teradata Error Codes
In Teradata every Error is shown by an Error Code and corresponding description. Sometimes while using some utilities we may have some records in Error Tables. At that time we can see ErrorCodes in...
Author: Raj
Teradata view recent queries
Most of the time you may wish to revisit to previous tasks and look for queries you ran to accomplish that adhoc task. To view recent queries in Teradata there are two simple ways...
Table Space Utilization in Teradata
We often come across the situation when we need to find out how much space a table in our database is actually occupying in Teradata. This may help us in identifying the tables which...
Difference between RANK and ROW_NUMBER in Teradata
In Teradata , OLAP window functions play an important role while handling complex SQL requirements. There are various WINDOW functions available in Teradata. However two of the ‘tricky’ OLAP Window functions available in Teradata...
Teradata Datatypes Size
In Teradata it is actually very important to know what is the Storage size required by the different datatypes.If you know the storage requirement of different datatypes used in your tables in Database, you...
UTF-8 Unicode Character Set in Teradata
How to handle UTF8 Unicode Character set in Teradata.Teradata provides few of the best data loading utilities to its user namely Fastload and Multiload.Both of the utilities are extremely popular in Teradata Database world.User...