DSXchange

Did you TRY a Merge stage, or simply doubt my advice?

In that case I'm puzzled. Does the error message occur consistently and reliably? If so, can you post the job design? Otherwise report it to your support provider, complete with reproducible test case.

Welcome aboard! :D Reading the appropriate chapters describing each stage type in the Parallel Job Developer's Guide (parjdev.pdf) will aid your understanding. A quick, and necessarily incomplete, summary is: A Sequential File stage accesses regular operating system files, such as CSV files, text fi...

If running a job from Director you can set the number of warnings before an abort on the Limits tab of the Job Run Options dialog.

Three of the conditions are straightforward.

IsNull(A) And IsNotNull(B)

IsNotNull(A) And IsNull(B)

IsNotNull(A) And IsNotNull(B) And ...

where ... is any other comparison needed to detect a change.
Outer joins return NULL for columns from rows (links) where there was no match.

You can rely on implicit casts in a BASIC Transformer stage.

Use nohup - this is the UNIX method for starting a background process that does not "hang up" (= log out) when its parent logs out. You still need the final ampersand to start the process as a background process.

These have not been published, and do not exist anywhere. You can deduce some them from the header files in dsinclude. DS_JOBOBJECTS is not a conventional table. It has many different record structures, ranging from nine to 308 columns, depending on the particular object type. Further, some of those...

Things that are "promotable", for example int8 to int16 or int32, can convert implicitly in parallel jobs. Otherwise the conversion must be performed explicitly. There is a table explaining this in the Parallel Job Developer's Guide, from memory in the chapter on the Modify stage.

Use a server job Merge stage which allows any kind of join between two sequential files, including full outer join.

The really interesting question here is how Chuck in Virginia USA knew that Rajasekhar in Bangalore (India) had checked the Omit check box

Welcome aboard! :D

This topic has been discussed before (though from memory it was "add business days to a timestamp"). Search this forum and I'm sure you'll find some examples that you can adapt.

Welcome aboard! :D

This topic has been discussed before (though from memory it was "add business days to a timestamp").

Please provide more information about "unexpectedly". What did you expect, and why? What does the help/manual say about the null handling functions? Are you expecting something else? What actually happens? how do you prove what actually happens? And remember that "" is not the same as NULL. One know...

You do it the same way, but you do NOT want to run multiple instances of parallel jobs. Ever.

Multiple instance is simply a way to achieve partition parallelism in server jobs, which happens automatically in parallel jobs.