DSXchange

I answered the question in the subject line.

This does seem to be a strange requirement, but it can be done. Add an artificial key such as line number. Use a Copy stage to split the stream into two, with one column in each stream. Sort sname in reverse order and generate a new line number for this stream. Use a Join stage to inner join the two...

You can't make those conditions on the lookup since you don't have the ref keys when that decision has to be made. You can, however, construct such a test once all the lookups have been attempted.

If you have two loops, use "odds and evens". More generically use Mod() of the line number in the list of filenames divided by the number of loops.

You could use a design with more than one loop, the loops executing concurrently to process distinct subsets of files.

Your actual question is why Round Robin partitioning algorithm has not distributed the rows absolutely equally. This probably has to do with the blocks/buffers in which data are transmitted - parallel jobs do not work row by row. Have you asked your official support provider? How wide are your rows?

You could use a message handler to demote the warnings to informational messages. Or you could investigate which fields are missing, and either modify the schema file or the data to make sure that the two coincide.

bobyon wrote:Is the only way to put one job in a sequence for each compute passing an explicit config file for each job?

That, or a job that has a configuration file mentioning every compute node.

/opt/IBM/InformationServer/Server/PXEngine is the default location.

Parameter references are not introduced by ampersand; rather they are enclosed by a pair of sharp signs. You may find it easier to pass the entire SQL statement as a job parameter.

What is the URL of the page that is not found?

prasson_ibm wrote:Can anyone help me with above issue.

Possibly and, if they can, they will. "Pushing", which is what you are doing, is offensive.

"-" is not correct for showing a signed number. "S" is.