Tag: ETL
February 25, 2018
/ Technology
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…
February 25, 2018
/ Technology
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…
February 25, 2018
/ Technology
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…
February 25, 2018
/ Technology
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…