DSXchange

Care to be more specific? I am concerned that at least one of these terms reflects misunderstanding, or worse, in the composer of the question.

Even in the Knowledge Center (once I'd figured out what to search for!)
http://www-01.ibm.com/support/knowledge ... ility.html

So the next question is...

Does anyone have an example of this in production?

Seems that the answer is "yes".

One document is here:
https://www.ibm.com/developerworks/comm ... ent+Server

InfoSphere Information Server engine tier (DataStage, effectively) supports active-passive high-availability configuration. Does InfoSphere MDM also support high-availability configuration and, if so, where is this documented?

Are these interview questions?

If not, where do the questions (and the terminology) come from?

If your primary key data values are skewed there is ABSOLUTELY NOTHING you can do about except point this fact out to the DBAs.

What about the output link from the Join stage? Are they all nullable there? (Particularly the ones coming from the "Right" input?)

The Ops Console database is, typically, referred to as DSODB. It's fully accessible and fully documented (in the manual and in the IBM Knowledge Center). You ought to be able to get whatever you need directly from that database.

DataStage 9.x and later has its own, inbuilt, workload manager.
See here for an introduction.

Looks like the metadata are specifying a default value and that null handling is not enabled on the output link (that is, the output column is not defined to be nullable).

Do you have a reject link to capture your empty rows (since they do not match the metadata)? Are there warnings in the job log reporting that import failed for two rows?

Although not programmatically, you can also use DataStage Designer to compare designs across projects. This would be useful if you suspect that there are differences between environments, or simply to confirm that what's in DEV hasn't changed since it was last promoted.

If you are using DataStage Operations Console (and its associated database) this information is already being collected and stored.

In version 11.3 Business Glossary and Metadata Workbench are combined into Information Governance Catalog. Version 11.3 supports single sign-on across all browser-based clients. I have not yet had the need to research anonymous login to IGC or to Glossary Anywhere in version 11.3, but would suspect ...