DSXchange

Are you using the same configuration file? Are you specifying Overwrite or Append? Does the job score include a composite operator that incorporates deletion of the Data Set?

Welcome aboard.

Are they really Date data type, or is one or both a string? Without knowing the data types, we can not provide a cogent answer.

aakashahuja wrote:But PX pdf mentions that this can be done

Where?

Surely it's just a regular join on cust_id? Do this without the Join stage; do it in the Oracle stage.

Not possible. In version 7.x, the MQ server and the DataStage server must be on the same machine. This restriction is removed in DataStage version 8.

Not in server jobs, they're not! Use either a three-digit decimal ASCII value (such as 009 for tab) or a four-digit hexadecimal Unicode value.

This is almost certainly not a metadata issue.

Moderator: please move to server forum

As a test, add @FALSE as the constraint expression of the second Transformer stage so that rows are not being sent to the XMLOutput stage. Report your rows/sec under those circumstances, then re-think where you're placing the blame.

Why not have just one output, and direct the rows (in a Transformer, Filter or Switch stage) based on the Change Capture result?

Not possible. Use a different configuration file.

System variable @INROWNUM will give you the input row count per node in a Transformer stage; since this is the only stage type that supports stage variables I assume that is what you have in mind. You can also get the input row counts in the Director, most easily in Monitor view.

Pay close attention to the phrase "each user" - this includes all section leader and player processes on LPAR2.

It is generally better to leave the conductor node configured, because the Conductor process needs access to the DataStage job log.

Is there any information in any of the fields that indicates the record type as header, detail, trailer? If so, simply use that value in the constraint expression of a Transformer or Filter stage.

No but, since DSParams is a text file, it could easily be done with appropriate care not to break the file.