DSXchange

Could you explain bit more on "securities loading"

Is the filename or the path been passed as a parameter? If so check if the value been passed correctly in the previous call if that been called by any master job.

Since its Server Edition, Merge stage can hold only 2 inputs at a strech. I would suggest, to divide this into several jobs. And write the output into a temporaty table as when required. If the temporary table was required to be lookup to the subsequent job, built Index on the lookup key after the l...

only in that specific stage.
You cannot do it in ChangeCapture Stage alone. Try with Difference stage or Compare Stage or ChangeCapture coupled with ChangeApply stage.

I guess, now you got different error than what you pasted above

Include an entry in dsenv which points to "..Ascential/DataStage/PXEngine"

You can execute either in Adminstrator Command or in TCL prompt.
i.e., $DSHOME/bin/uv after sourcing dsenv will get you to TCL prompt.

If you are ready to use Hahsed file, you can read the hashed file using Hashfile sage, and find the max, use transformer and file stage to replace with the value in the target hashed file. Since it has advantage of, being able to update and read simultenoulsy.

Data files of the Fileset are in ascii readable format. The aproach that you might have tried to read dataset, will try to convert the data in internal format of datastage into the readable ascii format.
The path and file name of the datafiles will be in the control file with .fs as the extension.

Better think about using lookup for this.

Change the ChangeCapture into Join-Transformer.

Check the column defenition from 150 to 240 for any missing ',' or ')' or ';'

What stopping you from using the Userdefined SQL query, and updating the Audit table after the job.

It the updated/Inserted record would not required to be updated/refered 2nd time in the current run, then read one file and update another file with the same content, and copy the updated file to the original file after the job run.

Maintaining a database will need to have manual intervention to maintain, whenever you add a new job. Else you need to have a regular job which keeps track of the new job. Just the query for the Job Number in DS_JOBS will the unique number at any time. (Unless you deleted the job and reimport the sa...