DSXchange

Welcome aboard.

The structure of the repository is not documented.

It makes use of a non first normal form database which, among other things, allows different record structures within the same table.

Wait.

A single operator will run in a single process on a single node. Always. In a multi-node configuration, the same operator will execute in a single process on each of the configured processing nodes. Only in that sense can you say that an operator runs in multiple processes. Note that one stage might...

Was the export taken from a system on which NLS was not enabled?

There are many possible reasons why you (your job) may have tried to access a memory address to which it is not entitled. That's why I asked you to search - there is no point trying to guess what your particular cause is. APT_DISABLE_COMBINATION will assist your diagnosis only if the error is being ...

To put that another way, DataStage itself does not use hints. So whether hints will make anything faster depends solely on whatever impact the hints will have in the database.

No, because your requirement is unclear (or very unusual). Please provide examples.

Do an internet search for "SIGSEGV" (segmentation violation) then tell us about what memory-hungry operators are mentioned in your score.

Welcome aboard. Please Search DSXchange for "-14". This question has been answered many times.

SQL Server Enterprise stage is not available on any UNIX/Linux platform. You need to use ODBC Enterprise stage.

First, remove your duplicate post before anyone responds to it. Second, please post in the Server jobs forum. This forum is to suggest topics on which someone might write an entry into the FAQ forum. Once you have a post in the Server jobs forum, some kind soul might answer it. There is an easy answ...

This very question has been asked recently. Perhaps you could Search for it.

There is a property called something Default Decimal Output that can be set globally (within the Aggregator stage) or for individual columns. You set the precision and scale for the decimal number, separated by a comma. You can also use this property if the target field is an integer of some kind (s...

What, I wonder, do they mean by "standard". The Wikipedia entry for CRC shows six (presumably different) CRC-16 algorithms.

Given that you're on version 7, the table definitions are stored in a table called DS_METADATA. The key is made up of the category and the table name (which allows you to have apparently duplicate table definition names). SELECT DSRID FROM DS_METADATA WHERE DSRID NOT LIKE '\\%'; will show you the ke...