Tag: ETL
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 –…
February 25, 2018
/ Technology
LUTCreateOp and LUTProcessOp
DSxchange, every now and then, comes up with some very interesting discussions thanks to the DataStage gurus like Ray, Craig,…
February 25, 2018
/ Technology
Aggregator Methods in DataStage (Courtesy: Ray Wurlod)
Here’s another favourite from DSXchange by Ray Wurlod Hash aggregation builds a hash table of results in memory. There is…
February 25, 2018
/ Technology
What Exactly Are Hash Files? (Courtesy – Ken Bland)
I pasted this nice article by Ken Bland on my blog just for future reference. The original article can be…