DSXchange

All, for what it's worth. In INFA the hash file equivalent is a 'lookup' which is simply a sharable icon that contains an SQL statement. The data can be read from the database or from memory. In memory I believe it is binary searched. If read from memory any job using that lookup will share the one ...

Hi Kenneth,
thanks for your input.....all good advice, even the bits I wish I wasn't reading.

I think I will ask my boss to have our DS guru go somewhere he can find out more about PX more quickly.....

Hi All, this is really just 'thinking aloud' and asking am I thinking correctly. 1. We have completed development of an ODS using Server jobs. (60 or so that are important to this conversation. 140 will never be PX.) We have just got our 12K dev machine available and started production volume testin...

Hi Sim, the best way to write DS jobs is to have them completely restartable from the beginning of the job because you really do not get very good control around 'transactions' against many tables in a database. This usually means that when you are inserting records use the insert then update option...

Tom, thank you for the warm welcome. I've been on oliver for what seems like years now. I don't know why I have not joined DSXchange before now. I'm lucky enough to have Thomas Nel as my DS Guru on my current project so he's been asking all the questions......we are just about to fire up our new sun...

Hi All, I've just joined this forum and I thought I'd start on the right foot by contributing.... Ever had to make the same change to a lot of jobs? Like trim tailing blanks? I did, so I wrote a vb.net program that reads and exposes all the datastage elements in an xlmdocument. Saved us a very unhap...