Jirka's Public Notepad

Data Engineering | Python | SQL Server | Teradata

December 6, 2018 By Jiří Hubáček Leave a Comment

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

August 13, 2018 By Jiří Hubáček Leave a Comment

Hello Australia!

In the early 2018, I decided to leave Germany to experience another country, its culture and manners. Shortly after I span my search, I got an offer

December 19, 2017 By Jiří Hubáček Leave a Comment

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

December 15, 2017 By Jiří Hubáček Leave a Comment

Bitcoin 1.0

I've been recently asked by my friends how does this Bitcoin thing work and how can one get one. In order to avoid repeat myself , I've compiled a

October 15, 2017 By Jiří Hubáček Leave a Comment

Java Pinger, part II

This is the second and final part for my Pinger utility. The most recent up to date code is on my GitHub account. This post is about configuring

September 22, 2017 By Jiří Hubáček Leave a Comment

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

«
»
  • GitHub
  • LinkedIn
  • RSS
  • Twitter
© 2022 · Jiří Hubáček, PGP