DSXchange

I disagree.

What does a "reject" mean in the context of a join?

When I join tables using SQL there are no rejects!

You need to create another job, with the Surrogate Key Generator stage having only an input link. Up to you how you poke the "1" onto that link - a Row Generator stage suggests itself.

That's fine provided that the incoming date string is in precisely that format. If, for example, it has a single-digit day number, or a date earlier than 2000, or a non-standard month abbreviation, then it won't match the picture.

It's an environment variable that exists in the Administrator client, in the Reporting group. You can add it to a job as a parameter using "Add Environment Variable" in the Parameters page of the job properties dialog. Once it's there leave its default value as False and only set it to Tru...

Yes. Same out as in.

{x80} is the internal representation of an out-of-band null. Check that nulls are beig properly handled.

Welcome aboard. The answer depends on the data type, but in each case the format of the date/timestamp in this field does not match your default picture. You can specify the format as a job property or even as a column property. The project defaults may be found on the Parallel tab in the Administra...

Once you upgrade to version 8 you get the ability to have DataStage capture performance monitoring information and a Performance Analysis tool that gives highly detailed information.

In version 7 the administrator is defined as dsadm therefore your Step 2 is not possible.

Nor have I encountered the term. Where did you hear it?

If you run the reject link from the Transformer stage (on which you can capture DBMS error code using output link variable) you could use an output row limiter set to 1. That would cause the job to abort. It's not really an approach I advocate, but if that's what you want to do...

vishalsongra wrote:I was able to do so before and suddenly it stop working.

What has changed?

Are you able to reverse that change?

It's possible. A DataStage job will wait until it receives a response from Oracle that the transaction was committed successfully, before the job finishes. This is not a guarantee that all the data are in Oracle tables, though it is intended to be a guarantee that all the data will get into Oracle t...

Accented characters do not exist in pure ASCII. You will need to re-think your requirement.

Whenever you compile a job or a routine, the precompiler first performs a check to make sure that the object being compiled is not referred to elsewhere in the project. The more objects that exist in the project, the longer this check will take. I suspect this is the main cause of the degradation yo...