DSXchange

Try it and see. (One row does abort the job. But don't take my word for it - a test job would take less than two minutes to create.) Your additional requirement is not part of the original question, but could easily by solved by creating a column derivation or even constraint expression on the secon...

Get a DBA. Seriously. No Oracle site should be without one. On the server, issue the command oerr ORA 12535 to discover what this error code means and, if you're lucky, what remedial action is appropriate. And please do co-ordinate with your colleague so that we aren't answering the same question tw...

Etiquette Note
If you want information about DataStage, please use only English and IT industry standard acronyms (such as ERP).
Abt, interestingly (for some) is a mechanism for allowing trains to traverse greater gradients than plain steel rails. This link will provide more information.

It's certainly NOT an Aggregator-related problem - these don't generate Oracle error codes!

Fmt() can do rounding - use "T" in the format specification to get truncation. For example for two decimal places (rounded) you might use Fmt(InLink.TheString, "10R2") More flexibility is available with Oconv() using an "MD" (masked decimal) conversion. Get into the help, and find ...

In the derivation window (double click on the Derivation field) you specify the input column - the drop-down list on the left hand side - and either check the "group by this column" check box or choose an aggregate function from the right-hand drop-down list.

The -logsum option can be qualified with timestamps to restrict the range of events reported. Either search the forum or consult the manual; it's well explained in both locations. You could also interrogate the log to find the newest ID of a job control message ("job starting") and use that as your ...

Check your report again. Maybe you didn't face 79 questions. Maybe now is a great time to take the exam, while you can pass with 56 correct!

Create another output link from the Transformer. Its constraint is the logical inverse of the constraint you have been using. On this link set Abort After Rows to 1. The link can connect to a Copy stage with no output. This will consume the row if it gets that far.

The second promotion would allocate a new version number, unless you'd manually spun up the tertiary portion of the version number in step 2.

No.

The logs are created when the job is created.

If you're asking about log entries, the answer is yes, using message handlers. But it's a dangerous thing to do. Far better is to diagnose why warnings and errors are occurring, and to prevent that.

If these are inserts only, why not use a direct write (bulk load)?

Can you partition your data onto more processing nodes, so that smaller transactions come from each node? That way you don't have to worry about all the logic - the engine can perform it for you.

Except that sequential files don't have "catalogue tables".

Why do you want to do this? There is a bulk unloader, called UNLOAD.FILE, that creates a text file that can be used by the bulk loader loadfile. Before you can use UNLOAD.FILE it needs to be cataloged. However, the format of the text file is specific to loadfile, and contains tabs and other markers ...

Set standards and best practices, and document them, before rollout. I agree with Wolfgang on the recipients. Require compliance with standards and practices, and punish transgressions.