DSXchange

Welcome aboard. Status 2 is an operating system code meaning "file does not exist". This may mean that the file itself does not exist or that one of the directories in its pathname does not exist, or that somewhere in that path you lack sufficient permission. The fact that the error message includes...

Sure is. Sequential File stage, either with a Filter command as indicated, or with five output links. --------------> Seq --------------> Oracle File --------------> OCI stage --------------> stage --------------> And that's just with server jobs. In parallel jobs there are even more options, for ex...

Which sets go into your matching area and which go into your clerical error depeneds entirely on where you set your match cutoff and clerical cutoff. Aggregate weights larger than the match cutoff go into the match area. Aggregate weights between the clerical cutoff and the match cutoff go into the ...

DataStage jobs do not just comprise a single executable component. There are configuration records, status records, log records for run time, and of course design time components also stored in Repository database tables as well. Why, particularly, do you want to delete the executable? Without seein...

That one's easy. Just have the player processes report their pid when they start - the messages will be logged from their own node. The environment variable, from memory, is APT_PM_SHOW_PIDS.

I presume DSLink16 is the name of the link between the Transformer and Sequential File stages. What is the value of the File property in the Sequential File stage?

Oracle Enterprise stage using direct write (effectively parallel bulk load).

See my response to your other thread.

This one looks like a good candidate for a local message handler, to demote the warning to an informational message. It's not strictly required that the upstream sort be exactly right for the RemDups stage (as you have demonstrated); but DataStage alerts you when it isn't.

Always push back on stupid requirements, and you can tell the PHB that I said so. The categories on the Palette are totally customizable - you can readily move a stage type into another category to suit your personal whim. Row generators and column generators particularly are used in lots of product...

Welcome aboard.
Partition numbers for four nodes are 0, 1, 2 and 3. Partition count is 4.
Plug these into a generator using partnum for initial value and partcount for increment; on the fourth node (node #3) the values will be 3, 7, 11, 15 and so on.

Yes it is. It is written in very clear English. For less than 30c per day (currently about Rs12) you can purchase premium membership which would permit you to read complete posts by the five premium posters. Revenue from premium memberships is totally dedicated to meeting the hosting and bandwidth c...

Put the most likely one first and the least likely one last, for maximum efficiency.

Yep. Wanted to make sure that BUSINESS_UNIT and OPERATING_UNIT were correctly defined. They are. Therefore I believe your code ought to be OK.

That's right. You have to update the other two columns with exactly their same values.