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 –…
LUTCreateOp and LUTProcessOp
DSxchange, every now and then, comes up with some very interesting discussions thanks to the DataStage gurus like Ray, Craig,…
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…
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…
Transformer Date Derivations in DataStage
I’ve formulated a few derivations to calculate certain dates (Listed in BOLD). If your time dimension cannot help or you…
DataStage Orchadmin Reference Guide
export DSHOME=$(cat /.dshome) . $DSHOME/dsenv export LD_LIBRARY_PATH=$APT_ORCHHOME/lib export APT_CONFIG_FILE=$DSHOME/../Configurations/default.apt export PATH=$DSHOME/bin:$APT_ORCHHOME/bin:/$PATH NAME orchadmin – delete, copy, describe and dump ORCHESTRATE…