DSXchange

And dataset and fileset can be use only by datastage. For outer worls sequential file will be the only choice.
Untill now i dont find a vivid use of fileset. Since any any further use, we should rely on datastage. Dataset can be opted for the same purpose which is more effecient.

Irrespective of type of file if it is compressed, Binary mode should be opted.

Was record/field delimiter properly set?

Also may be due to missing keywords such as DSJOB or DSSUBRECORD or DSRECORD or HEADER or DSROUTINE or DSSCRIP or DSEXECJOB next to BEGIN.

If the input is numbers, Make is as decimal. By default 0s will be padded at left.
Or you can also use . Again you need to follow Johns method to pad to left.

For better performance, dedicated sort sate can always be chosed. Which has its own strach disc space. Unix sort make use of the unix level sort option. It may be more effecient for data with less number of records. If the incoming data is previously sorted, you can enable Already sorted option to g...

Yes, but not always. If the child process left orphaned, and the socket may still be open (though the actuall process is not running in server). Which will leave out the zombie process. Hence if you start the server before the the connection dies, RPC daemon may not start. And it may give you error ...

vmcburney wrote:I think your could add to your resume "Uncertifiable DataStage Programmer". I would definitely need to study after getting a couple of the sample questions wrong. Am I the only person here who has never heard of dssearch?

Mentioned in Release notes but not much descriptive.

We went the route of one big project. Which as stated above has 0 bearing on job performance. Your server(s) are going to be capable of a certain workload and the number of projects that you have does not have an impact. What I don't like about it is the amount of time that Director takes to refres...

Though project doesnt takes up the memory directly, the project folder where all the objects reside (RT_STATUnn,RT_SCnn,RT_LOGnn,RT_CONFIGnn,RT_BPnn,RT_BPnn.O,DS_TEMPnn) may require memory. As i mentioned, if most of the jobs and logics and category are about to be replicated, it is again replicatio...

If the input is or row basis. The above logic can be performed in the basic transformer it self. Just assign a varchar 255 column. And read each row from a sequential stage and user Stage varialbe in the transformer to acheive tha.
BTW: Congratz!! To become a member. :D

Hello Craig and all others, Is that the reason why i am not able to use $PROJDEF in my 7.1r1 Datastage version. I am trying to use envi variables with $PROJDEF, it only gives error as invalid charector. Could some one explain the use of userdefined environment tab present in the admin window for 7....

This is for repeatability. For instance if there are seveal files with similar structured which need to be processed with same logic say validation, single Multiple instance is created and file names are passed through parameter. Hence n number of instance can be instanciated There are many instance...

There is not numbers given for maximum limit for projects. Still it may not be too effecient to have more number of projects in a machine. If you have a set of code which likely to be repeated for all the projects, it is better you dont create a new project. Try to manage within a project. Projects ...

Click the right side of your post. Or click on the following http://store.yahoo.com/dcs-strategies/l ... edtr1.html