DSXchange

in simple No need to export the Metadata to UAT, if you are not using XML stages in your jobs

DataStage can't read any file from the mapped / shared drive. It is a limitation in DataStage.

Hi Everyone I have got new problem, Earlier I thought of first name and last name only Now I have prob with middle name For example: From the source I am getting a name called "kenneth charlie Browne" in the transformer the name should get split into only two columns called first name and...

you may use

First_Name=Field(fullname,' ', 1)
Last_Name=Field(fullname,' ', 2)

in transformer.

You can use Multiple Instances enabled in DataStage Designer and create 4 instances of the server job in Director.
While running from the Shell script you can specify which instance need to run by just appending the instance name at the end of job name.