DSXchange

The Web Console is browser-based. Unless you specify desktop shortcuts it won't appear on any list. You can invoke it with the URL http://servername:9080/ibm/iis/console where servername is the hostname of the services tier machine.

Welcome aboard.
Did you enter the EXACT URL specified by the installer?

Try Help About in one of the clients.

My guess is that it IS an XML data type, because the error message is coming from Oracle. My further guess is that you are not working with well-formed XML.

Is it really being converted, or is it simply a deficiency in the data viewer?

That is, is the registered trade mark character successfully being processed into your target? DO NOT rely on what the Data Browser is showing you - it is quite limited in the characters that it can display.

Specify Modulus or Hash (with ID as the selected key) as the partitioning algorithm, on the Partitioning tab of the Input link properties in the Sort stage.

I think we need to wait for the OP's answer on this one.

Partition by ID. Sort by ID and Pin. Use Remove Duplicates to preserve last record in each group, where groups are defined by ID.

What do you mean by "shuffle"? Sort? Use a Sort stage.

Each operator in a parallel job runs in a separate process anyway. So it could be argued that two flows in one job would use fewer processes than two jobs, because only one set of (conductor and section leader processes) would be required.

You can do that. Use user-defined SQL in the Oracle stage that provides rows to the reference input. Pass a constant (say 'X') as the "key" and, basically, ignore it in the Oracle stage.

I can't recall whether the Help in HFC provides the algorithm for modulo. Replying to Colin by PM.

Welcome aboard. Did you download Information Server for some other platform?

You really need to ascertain why this is occurring. Has someone (or an inactivity timeout) killed the window/session from which the installer was started?

You are correct that you can restart the installer and it will skip any task that has been checkpointed as successfully completed.

Data are sorted separately on each partition.

Partitioning (and within-partition sort order) is preserved in Data Sets.