DSXchange

OK, it's page 508 in the version 7.5 manual, and it's not something I've ever used. I assume you can use a prior output column, rather than an input column, and apply some further calculation to that. Why not experiment (for example what column for recalculation appears in the drop-down list?) and l...

Padded with space from one source and with APT_STRING_PADCHAR from the other?

Please use English to post on this forum.

What is unclear about the diagnostic message "DataStage row size (964) does not match BW Transfer Structure row size (962)"?

It still has to depend on what you're doing. You need to read the information about what's changed in Oracle 9i (the "i" stands for "internet"). I doubt that very much has been done for SELECT performance. Make sure your joining columns are indexed, so that the join can be resolved in the indices.

OPEN and OPENPATH open a hashed file or directory for random access (by "key").
OPENSEQ opens an operating system file for sequential access.

No PRIMARY KEY clause?

Your Search for "access violation" would have revealed a number of possible characteristics of your data or design that might result in such a signal being raised. These include inappropriate handling of null values and oversized string data.

You will notice within the generated code some $INCLUDE statements. The line numbers in the diagnosis count the lines in the included files. That's why there is a discrepancy. However, you ought not need to inspect the code to resolve this error. You have tried to effect some numeric operation (arit...

There is an error in the Parallel Job Developer's Guide in the Modify stage chapter. The name of the function that handles null values is incorrectly given as NullToValue(), which is the Transformer stage's function. In a Modify stage the function you need to use is handle_null(). But didn't this th...

Are these "+" signs in the data or in the column names?

Can you attempt the same inserts using a different client, one where you can manually control the COMMIT interval?

How many of the 50 non-key fields are actually used in the job that consumes rows from the hashed file?

Sorting is heavy duty activity, as anyone who has even been given the task of sorting a deck of playing cards can attest. It WILL consume your CPU resources. The figure reported is (CPU seconds / clock seconds) for each process in question. That is, each Transformer stage is reporting what proportio...

What's the difference between a hammer and a screwdriver? For driving a screw which is better? Why is it better? (You CAN drive a screw with a hammer, and faster!)

Etiquette Note
It is not the purpose of this forum to supply answers to inteview questions.

There are many more than two types of hashed file.

These manuals are shipped with the SAP PACK from the vendor. If you have the SAP PACKS (and therefore the plug-in stages) you also have the manuals. If you don't have the software the manuals are not going to be much help, because they explain how to use the stages. Incidentally, there is another PA...