DSXchange

It's the same rules for the Execute Command activity as in the operating system. An exit status of 0 is considered to be "success". Anything else is considered not to be success. DataStage jobs return 1 for success, because they return 0 for "running" when their status is queries...

Learn patience. Some of us have to earn a living. How are you creating your hashed file? That will affect how you define multi-valued columns. If you create the hashed file with CREATE TABLE then you use the keyword MULTIVALUED as part of the column definition syntax. If you use Hashed File stage yo...

Could be - would need to check the Score. (Auto) in that case *should* give you Round Robin partitioning.

If you're selecting from an Oracle table, include the functions in the derivations of appropriate columns.

AddDays() can be achieved with DateFromDaysSince() function. There is no direct equivalent for AddMonths() but you could write your own.

If you don't yet have the report, how do you know that "performance is not good"? And what do you mean by "performance" in an ETL context anyway?

The obvious answer to your first question is that you will see different results whenever there are different results to be seen. For your second question, CCustomInput is the class of input links to custom stage types, and CCustomOutput is the class of output links from custom stage types. In this ...

OK, my example is where an upstream stage executes in sequential mode, for example a job that only has a Sequential File stage and a Data Set stage. It's in that kind of case that the parallel placement of data is impacted, even though the Data Set stage (copy operator) is shown as executing "i...

Technically // is not legal in a UNIX pathname. That's your root cause.

Some UNIXes ignore it, but technically it's illegal.

Teaching someone to fish is always better than giving them a fish.

No, you posted in the Enterprise Edition forum, but marked the job type as server. That's not the same thing as posting in the Server Edition forum.

Did you test that, Aquilis ?!!

ds_search2008, 0.5 hours and 5 minutes are not the same thing.

Investigate the time conversion functions with "Since" in their names.

Put the pathname of the script in the Input Values field.

You can execute any valid UNIX command (though some would, of course, be unwise, such as halting the machine).

Why do you have this concern?

I expect it is based on out of date information, unless you have version 7.0. Transformer stage "performance" problems were addressed in version 7.5, as has been mentioned here a number of times.

Can you not add a Remove Duplicates stage on the Right input?

You can not. It's a vertical pivot. A Search for that term will yield a number of solutions, particularly for server jobs.

Moderator: please move to server forum