DSXchange

Click on Help when you're in that page (Transaction Grouping). You can then click on the controls to get individual help about them. I am using an Oracle OCI (ORAOCI9) stage, and do not see these controls. Can you be more specific about what kind of stage you are using? The stage type appears in the...

Or SQL Server.

And it's only version 9 of DB2 and only version 10g of Oracle.

You can use Remove Duplicates and yet capture the duplicates. Upstream of the Remove Duplicate stage insert a Copy stage. On a second output of the copy stage insert an Aggregator stage that counts the rows, grouping by the same columns that the Remove Duplicates stage uses, then filter those rows f...

That's a message from a server job, not from a parallel job, unless you have a BASIC Transformer stage in the parallel job. Trace mode is a sum of powers of two indicating which active stage tracing options have been enabled when running a server job. It will always be zero in a parallel job, as tra...

First off, disable operator combination so you can work out which operator is having the problem. Resource disk is used only for Data Sets and File Sets. If it turns out that the stage having the problem is a Data Set stage, a File Set stage or a Lookup File Set stage, then you're close to a solutio...

It's not stored in XML files; it's stored in the common repository. XML is merely one way to report.

Aggregator will only remove duplicates if you group on that column AND ONLY THAT COLUMN.

Does that help to explain?

if you don't mind the bottleneck you can collect into a sequentially-operating stage and use @OUTROWNUM or @INROWNUM there, or use a database sequence or serial data type. All these suffer from the same issue; executing sequentially.

None of these environment variables has anything to do with the Surrogate Key Generator stage.

If you want a long list of environment variables, look in Chapter 6 of the Parallel Job Advanced Developer's Guide

Look in the Director manual or the on-line help while in Director. Choose Clear Log from Director's Job menu. Choose Immediate purge.

Interesting. Do you know what you did there, and why? Did whomever gave you the advice explain the possible ramifications? You could also have overridden sort insertion with an environment variable, but with the same ramifications.

Same problem though - the DLL is somewhere Windows isn't looking, or hasn't been installed. Do you have MQ Series server installed with your DataStage server? You need to.

Set the Write method to Load and the Write mode to Truncate.

There are (separately purchased) plug-in stages for working with IDOCs.
Do you have these installed? It's the SAP Extract PACK and SAP Load PACK, if my memory serves.

Even the manual can explain the difference between a Key Value column and a Change Value column.
The Key Value column must match before any other comparison will occur.
Change Value columns are the ones that are compared.