DSXchange

I don't think /tmp can be changed (but do feel free to issue an enhancement request). Try changing the value of the TMPDIR environment variable in Administrator client.

If you make users' umask 002 then other members of the creating user's group will be able to work with the files.

Defaults that are set in the Administrator client can be overridden in the job, and in function calls that specify a different format string than the default. It is these techniques that I mean.

Check the first sentence of my earlier reply.

Learn patience. The rest of the world does not work on Indian Standard Time. Further, the rules for producing the output are not well (clearly) stated. Try to come up with a specification in English about how each target row is to be produced from its corresponding source row. You might also answer...

"Help me asap"? If you tell us what asap means as a verb, then perhaps we may be able to help one or more ways in which you can, actually, asap. DSXchange is an all-volunteer site whose members post when and if they can. It is not a substitute for official support. We do not do "urgen...

Please post the exact error message. Your description of it is not clear.

A Search will reveal all you need. Try an exact search for APT_COMPILE_OPTION.

I'm not sure that it's possible. However, if it is, the technique would be to surround each parameter reference with sharp signs. Something like:

What is the Transformer stage doing, and does it call any routines?

1) Yes. 2) Possibly. However, I'd be looking at the default date, time and timestamp format strings in the two projects. Do this on the Parallel tab of project properties in the Administrator client. If the difference isn't there, check whether the defaults have been overridden differently in the tw...

Yes.

In server edition the internal format of dates is an integer, an offset in days from a particular day zero. You can probably discern that, for the assertion in the question to be true, that day zero is 1967-12-31.

Hmm, "jar" as a verb. Must try to use that in a sentence. Just made some marmalade and now need to jar it.
:D

That will depend on the settings in the Sequential File stage. In particular you can design what you want to happen - the line that fails to match the metadata can be dropped, can be diverted to a reject-handling link or can cause the job to abort. Those answers may further be amended if you enable ...