DSXchange

Welcome aboard :D

The stage you ment is for the very same reason.
As mentioned by Craig, unix level sort can be used for comparatively less number of records, and where as datastage can handle more than this.
You also have advanced option of cosort.
Also do a search on inline sort.

Its interesting to see timeouts can be parametereized.
Is it "#$FTP_DIR_Parm#TEST.INC timeout:":#TOTAL_TIME#:"/": #POLL_TIME#

Also it would be clean to have single project with multiple (controlable) categories rather than having multiple projects for each category. Logical seperation for project can be as DEV, TEST and PRD.
There can be multiple projects for the same class, for different versions.

IMHT

Perhaps you can try the same from Datastage Administrator client window command line.

Hi,
You can try to feed the same using the Nullable Field value in the sequential stage. Or the Default value option in the field properties to give your default vaule in the date column.

Check with View Data option.

Also do a search for vertical pivot.

Nail down the bottle neck.
Is your etl and database server residing in different server?
Have you tired Bulk load?
What if you try to do manual load.
Try to unload the data from the source table into a sequential file and do a manula load from command prompt.
What is the length of each record?

Q and A are from the same site is it

'Pin 1 not initialized' Here the Pin 1 is pointing to one end of the link 1 to the stage IDENT3.
Try to clear the hashed file and rerun. Also make sure you are running the job with the same user id.

The same could also be realised using merge stage.

Schema file is ment for the same reasone. Passing the name of the file as parameter shouldnt be an issue. Make sure the value of the parameter is getting passed correctly from DS Director log.

Do not delete any files produces under the project directory. Unless the parent job is being deleted. Delteing the fils like RT_* will make the jobs unuasble, sometimes the whole project.
Better try to change the default directry used to store the fiels in either case.

This error occurs if dsx file is curropted.
Try to import the same file into another project.

What is the target column datatype? What if some of the input fields comes as expetec (is it getting populated with either 'Y' or 'N')? What if you try IF (Trim(gender) = "Male" OR Trim(gender) = "Female" OR Trim(gender) = "Indeterminate")...