Unlike other database engines, Teradata doesn't support top N clause in suqueries (error Failed [6916 : HY000]). I came across this limitation when I
Timezone handling in Teradata
I needed to display local timestamps of UTC stored data in my report. But I didn't want to just blindly add or subtract hours as this wouldn't reflect
RDBMS error 2574: Operation not allowed: table is being MLoaded
Teradata Parallel Transporter (TPT) is a Teradata tool for Extraction Transformation and Loading. It offers a native, scalable and parallel way of
Casting Char to Timestamp and Date in Teradata
Casting character data to timestamp or date data type is a common task during ETL development. Yet, I couldn’t learn the formatting characters by
Listing all tables in a database and their PERM space consumption
Listing table sizes in Teradata is done by querying the all AllSpace view in the DBC database: [crayon-5d14994299222439461952/] 'All' represents an
Reverse string search in Teradata
I needed to perform a reverse string search to find the last occurence of a slash. It took me a while before I found a simple and elegant solution