Author: Jerome
October 5, 2020
/ Technology
Real Time Data Streaming Into Kinesis & Ingestion Into Postgres Using AWS Glue – Part 1 (Setup)
This April, Amazon announced support for serverless streaming ETL using AWS Glue. For the uninformed – AWS Glue is built…
October 3, 2020
/ Technology
AWS – Develop ETL jobs using AWS Glue Endpoints
AWS Glue scripts can have start up times that could be as long as 12 minutes especially if you are…
January 5, 2020
/ Experiences
Juggernaut Resolution
One of the things I have always struggled with, and I’m sure you’ll relate to this, is sticking to New…
February 25, 2018
/ Technology
NGBR-00019 – Input Dataset 0 not present in design time information
NGBR-00019 : Input data set 0 not present in design time information. Extended field properties for this field will not…
February 25, 2018
/ Technology
Replace Strings in DataStage
Trying to find a way to replace strings. e.g. In the string “chocolate”, I want to replace “choc” with “mock”….
February 25, 2018
/ Technology
Generate Unique Counter in a Parallel Transformer Without Surrogate Key generator
Old but handy trick. @INROWNUM * @NUMPARTITIONS + @PARTITIONNUM Update – To start the series from 1, use (@INROWNUM –…