DSXchange

Take the master and child links into a single ODBC stage. Within that ODBC stage set up a "grouped transaction".

Mark the second output link from the Transformer stage as "Rejects". This is a check box in the constraints editor. Leave the constraint expression for this link blank. The mere fact that it's marked as "Rejects" will cause it to capture database rejects from the first output lin...

Is there a Ctrl-Z character in your data? (This is the Windows end-of-file marker.)

Please post the exact error message. If it has sharp signs (parameter references) in it, then the parameters are not being resolved correctly. Check that the references are correctly spelled and cased.

View Data runs through an options window that allows you to limit the number of rows returned. Is yours set to 30?

1. Allocation of sequential operators to nodes is a resource allocation exercise when the score is composed. They are spread across available nodes. Note that Sequential File stages (import or export operators) will use import or export pools by preference, if these exist. 2. Repartitioning is never...

Use the Performance Analysis tool in DataStage.

Please confirm the number of nodes on which the LUT_ProcessOp operator is running, from the score.

The older jobs are getting compiled.For creating the new jobs we are getting the error Re-compiling when there has been no change to Transformer stage does not re-compile the Transformer stage(s) and therefore does not need the C++ compiler. If you change a Transformer stage, or compile using Force...

Sparse lookup is not supported for Teradata Connector, as far as I am aware.

You could be "going wrong" simply in your understanding of your data. If there are duplicate session ID values in the stream input each will be successfully looked up and therefore generate a row (each) on the output link. Also, verify that your Lookup Failed rule is Continue, which puts e...

Any valid UNIX pipeline can be used.

Are you executing the same UPDATE statement (for the same row) from each of two nodes?

Use a stage type that supports these operations. none of which is or requires a transformation rule.

Welcome aboard.

What is the character at offset 9 in line 245?