DSXchange

Not possible with current Information Server roles. You might submit an enhancement request through your official support provider, with a business case (or several) justifying the requirement. We tend to rely on the audit trail kept in the governance process, such that regular reports can be had of...

Of course it does. But not much.
And, no matter how you accomplish it, that amount of processing still needs to be done.

Right click on the expression and choose Validate Expression. The expression editor will give you a diagnosis.

Assuming that you don't need to check for a match on OldValue create a stage variable for each of the 150 columns, each derived using an expression of the form If RecKey = columnname Then NewValue Else svColumnName If you do need to check that OldValue is correct you have additional processing (more...

Prove that these records exist in Project B. Execute the SELECT statement (with hard-coded search string 'PRODUCT') from the Administrator client command window or from a TCL shell on the engine. Prove, too, that these job names exist in Project B. SELECT NAME FROM DS_JOBS WHERE NAME LIKE '%prd%';

Is the Preserve Type property available for the column for calculation? If so, set it to True.

Or add a simple server job (SELECT COUNT(*) FROM tablename) ahead of JobA in the sequence. This job stores the count in its user status area, and a Nested Condition activity can detect that value to determine whether even to run JobA (which, therefore, never needs to abort).

Arguments to Convert() are in the wrong order. And the names of activity variables begin with the "$" character. Try something like Convert(@FM, ",", ExecCommand.$Output) Build it with the expression editor so that you get hints about what goes where and don't mis-spell the activ...

NET AGENT is not the same as ASB Node Agent. You need to start the ASB Node agent (and probably the Logging agent as well, which uses port number 31533 by default). There is a single script (Node_Agents.sh) in the ASBNode/bin directory that starts both agents. This should be documented in your shut ...

ssnegi specifies a Join. There is no Join stage in server jobs.

prasson's is also a parallel solution.

No.

No levels of abstraction are available.

31531 is the port number used by the ASB Node agent (at least by default).
Until this is remedied you cannot assert that this is an Oracle issue.

Use a netstat command to verify that this port is listening.

Investigate the possibilities in a Merge stage.

Ignore ssnegi's response, which is not applicable for server job.

The ASB Node Agent is not started on the engine tier machine where your DataStage project resides.

If DataStage writes to a Sequential File what do you get?

Has you Oracle default date picture for this user changed?