DSXchange

Has anyone tried increasing the sequence cache size? The default is 20, meaning that Oracle grabs 20 numbers at a time from the database. If accessing the sequence a lot, increasing the cache size to perhaps 10% of your average batch size should increase performance.

For example to get the value of the DataStage environment variable ProjBaseDir from project Fred:

BASE_DIR=`$DSBIN/dsadmin -listenv Fred | grep ProjBaseDir`

...assuming the DSBIN Unix environment variable points to the directory where dsadmin lives.

I have a situation where data that I need to capture is already being sent via email to a number of recipients. The emails could easily have a new account added as a CC: address. The problem then is how to read the emails from the new account and land their text into sequential files for DataStage t...