DSXchange

That's just the name of the file.

The command used to create one of the files, based on the output from the HFC, was:

CREATE.FILE DEBUG 16 50321 1

Key structure is 4 decimal keys with an average length of 4 or 5, then 1 character key of length 5.

To answer your question: yes, I was kidding. Fear not, Craig. I already love hashed files. I've got pictures of them in my house and everything.

I suppose I should use emoticons next time I attempt a facetious remark, eh?

Hashed files are overrated anyway, right?

If you have any suggestions for how you would go about fixing this if not running the job was not an option, please let me know. Thanks!

Thanks for the suggestion, Ray. I was able to increase the performance while loading the hashed files, but the server is still experiencing the lagging issues while they are loading.

Any other thoughts?

We have a UNIX server split into zones (all on Solaris 10). On one zone is DataStage, on the other is our reporting application. I've found that when creating large hashed files (>20 MB or so), the performance on the entire server suffers (the reporting app slows down, it takes significantly longer ...

Great success! The Windows guys here suggested using Revo Uninstaller (freeware available at http://www.revouninstaller.com/), and I was able to get back into DRS stages again. Revo only works if the program you want to clean up is currently installed, so I had to reinstall DS in order to uninstall ...

Alrighty, thanks for the suggestion, Craig.

I'll see if I can fix the registry without blowing anything up. I'll post again afterward.

How would I go about doing that?

I'm running into a peculiar issue with Designer. I am unable to open DRS stages now. Any other stages are fine (I've tested transform, hashed file, sequential file, merge, ODBC, Oracle, UniVerse, etc.), but Designer hangs if I try to open a DRS stage. I can switch to that window, but I can't close i...

Thanks for the replies, everyone. I think we're probably going to end up flagging the deleted rows in fact tables. I just wanted to get some options from people that have actually dealt with this before, so I appreciate the suggestions. If I have any issues with the implementation, I'll either open ...

First of all, I apologize if this has been discussed here before. In looking through other topics regarding change data detection, I wasn't able to find an answer to what I'm looking for, but I may have missed it somewhere. If so, please point me in that direction. Most posts that I saw regarding de...

Not all of the rows from table A are joined to table B -- just the unique ones, which is less than 12,000. So the performance is pretty good. It took less than 3 minutes to read the 1.2 million rows from the database and write to a hashed file, then a couple seconds to read 12,000 rows from the hash...

That appears to have worked. Thank you very much for the assistance!

I'll try that out and get back to you. Thanks for the suggestion!