DSXchange

I would make your surrogate key a smart key like YYYYMMDD. This will save you a lot of work on lookups. I wrote one of these in BASIC for Michael Hester. Maybe he will post it or allow me to post it if I can find it. You usually have a couple of choices whn doing this in a routine. You can write it ...

A couple of other things which might be a problem. /bin/ksh DSHOME=/usr/local/Ascential/DataStage/DSEngine export DSHOME . $DSHOME/dsenv $DSHOME/bin/dsjob -run \ -mode RESET \ -warn 10000 MANC pa1 $DSHOME/bin/dsjob -run \ -param '$APT_CONFIG_FILE=/usr/local/Ascential/DataStage/Configurations/nod e1....

If you are in UNIX then the -param is the option and the ParamName=ParamValue is the option value and the whole thing needs quotes if there are spaces. So -param "ParamName=$ParamVariable" is more accurate. If the parameter value has quotes in it then you have yet another problem. Do us a favor and ...

I write parameter values to sequential files for another job to use as a parameter value. We run our jobs as scripts. The parameter values are stored in a directory below the project called JobParams. So if you want to know the last extract date in the fact table. So the script will read this value ...

I do not use the code posted. I doubt if Ray uses his. If you are running out of space because of log files then you have bigger problems. I like the autopurge settings. You need to get rid of any warning that you can.

Ray are you sad?

I have seen this before. I think you need to learn to create dictionary items and not use EVAL. It is less stable.

I got passed by 2B and Kumar. Get left in the dust.

I said they will not let me install all of EtlStats. I had it working the first day I had ODBC connections.

I was going to try to get back to metadata but it seems we have blown this topic completely out of the water. Ray was talking about metadata being communication. I have seen Ray's jobs and they are well annotated. The current customer has an annotation per stage. Everything is well explained for the...

Sorry, I have not read it.

I want to make sure that everyone knows that I do not consider myself to have attained anything. I am not yet a guru or great or excellent or beautiful or art but I am striving to be all these things. I am practicing to be great or wise. I am not intimidated by the greatness of others or their wisdo...

I think I am pretty good at a few things. Ray is great on a regular basis.

I have been thinking about that book all week and how much it changed the way I think. It is funny Arnd and Ray have read it too.

Me too but I told the customer it could not be done. Now I have to eat my words. Thanks Craig or Ray.

Zen and the Art of Motorcycle Maintenance This was one of my favorite books. Ray mentioned it a few days ago. This book is not really about Zen because I am a Christian now and I would not promote any other religion. It is about excellence, art, beauty and a way to view the world differently. In Chr...