DSXchange

The true value is, of course, reported in the job log. You can use the Help text to indicate what the default value is, perhaps even the parameter prompt.

Seems too complex to me. I'd use:

In general, join in the database itself, so that the ETL tool has fewer rows to process.

If it makes sense when you view it in DataStage without any transformation then it's ASCII.

There is an environment variable (APT_PLAYER_MEMORY) that you can set to True to report the memory demanded by each player process. The next ("Hawk") version has some more flexible estimating tools.

Check out the IsValid() function.

It is working as documented.

If you find that hokey, then so be it.

Change your prompt text to be the same as the parameter name if that's what you need. Why do you need to see the parameter name anyway? Generate job documentation; it's all in there.

Neither is cat synonymous to UNION. A UNION removes duplicates; cat does not. Nor is UNION a join.

You already have all the documents. They are in the Docs folder where you install your DataStage client (by default C:\Program Files\Ascential\DataStage\Docs).
The three of most interest to you are:

Parallel Job Developer's Guide

Parallel Job Advanced Developer's Guide

Core Developer's Guide

Aggregator stage. Set the aggregation function to Last for every column.

cat is NOT the same as join.

dnsjain wrote:2. It uses UNIX authentication but allows users to login into DataStage even if their UNIX password has expired.

I would be very surprised if that were true.

The delimiter character is "|" as stated earlier, but there is no "|" character in any of those records. This would only work if your record schema referred to one field only.

There's a logical inconsistency in your question. If it's static then surely there's no need to update it? Am I missing something here?

Please post the full error message, so you (we) can determine in which stage it is being reported. A S S E M B L Y , T O T E S T T H E F U E L H O S E ( T O P U M P C O N N E C T I O N O F E F I B I K E S ) is the data from the beginning of the first row in whichever file is generating the p...