DSXchange

That's almost certainly not the event you're waiting for. Inter-process row buffering is for server jobs, not parallel jobs.

Search the forum for explanations of when this error message arises.

If source1 and source2 are in the same database, also consider doing it in the SQL, where the query may benefit from the table's indexes and/or statistics.

You will need the additional constraint in the Transformer stage that your original requirement peculiarly stated that you don't want to have.

Not "Andrew", but "Arnd". Arnd W. Your easiest solution is to insert all keys (Column 1 values) into an intermediate table (use a UV stage, re-creating the table). Then take two output links from this stage. The one to the target has SELECT Column1 FROM table GROUP BY Column1 HAVING Count(Colum...

Don't "write" it. Select it from the Expression Editor's operand's menu. It is a Link Variable; the first part of the name is the name of the link that connects to the Oracle stage (not literally "DBLINK"), while the second part is the variable name itself (REJECTED). So, if the link connecting to t...

Yes.

The method is in my immediately prior post in this thread.

Define "efficient". They use very similar algorithms for memory management. Do you need just a join, or do you need to be able to capture, separately, rows for which there was no "update" available? The decision is largely driven by functionality. Why not perform some benchmarks and document your re...

Welcome aboard. :D The default configuration file (default.apt) comprises two nodes, each using disk resource within the DataStage Engine directory - because the install script can be sure that this location exists. Your main considerations will be the volume of data to be processed and the availabl...

No. It's a built-in, hard-coded limit.

I would use a Transformer stage to identify and remove duplicates from one output, and direct all input rows to another output (the "rejects"). This approach requires sorted input.

Have you constructed a formal Batch (in Director), using a Job Sequence or using a job control routine? Or do you just want to run a series of jobs from a script one after another?

In the latter case, simply string together appropriate dsjob commands in the shell script.

If you want activities A and B always to run, check the "do not checkpoint run" check box in these activities.

sveeramani wrote:Both insert and update giving problem. I used in other jobs ,it's working fine.

What's different in the job that's giving you the issues?
What data type do you use for CLOBs in the jobs that you say do work?
Have you asked your DBA about space for CLOBs?
What error messages are logged?

cat if the server is on UNIX, type if the server is on Windows (you can also use cat on Windows if the DataStage version is 7.5x2, in which it will be executed by MKS Toolkit).

Two characters per row or two million characters per row? How long is a piece of string?