My Blog
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…
Notes on DataStage Bulk Load Using Oracle Connector
1. If you want DataStage to manage indexes during the bulk load, set “Allow Concurrent Sessions” to No 2. If…
ETL – Code, Build or Both?
Data has been growing at an exponential rate. Interestingly, it’s not just the volume of data but also the…
Business Alert & Exception Data Management within an ETL Ecosystem
Introduction Data transparency and trace-ability are critical to the success of any ETL flow. The business or the technical support…