DSXchange

900 is NOT 90%. 900 is "must match exactly". Read the manual.

It's how you notify ProfileStage that you have reviewed the Primary Key analysis, have made any changes to recommendations, etc., so that it is allowed to proceed with the next step (cross-table analysis).

1. No.
2. You can elect (design) for either of these behaviours.

Welcome aboard. While I haven't done it, the approach I'd take would be to use the Copy Management utility (rb_cm). Of course this assumes that there is a copy of Red Brick on the DataStage server machine, or at least the relevant executables. It's my understanding that you can do this. Another poss...

Case sensitive for the alphabetics?

Unless, of course, there is an overriding reason not to. We don't have enough information about the job design to pontificate on this particular point.

Your assertion, that the UniVerse stage works the same way as the Hashed File stage, is incorrect and therefore the remainder of your question is moot. The UniVerse stage uses SQL and therefore would need to be set to auto-commit (one row/transaction, array size = 1) to work in the way described. An...

Are these the job reports created from the icon in Designer? Why do you think these are saved on the server? At the very least the fact that there's a bitmap involved should tell you that they're stored on the client.

Not maybe. Definitely.

Usually any file name containing LU in a directory named as resource disk in a configuration file is created by creating a Lookup File Set. The next component of the file name is either the project or the job from which it was created (I can't recall which). Lookup File Sets have control files with ...

It's a solution. I don't particularly like it, but it's a solution.

Yes, but another Terminator in the main stream could cope with that.

I probably should have been more specific - not at their UniVerse default values.

You will need to check ALL your configuration files (particularly default.apt), and all those who might have used them. Are the data files recent?