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-5c12be4e1016f958373662/] '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
Teradata SQL: UPDATE using JOIN
Recently, I came across this brain storage distribution schema. IMHO 2% for 'stuff I should know for work' is a little exaggerated considering