DSXchange

I suspect what you may need to get out of that is the character associated with each hex byte. For example, 44 is ","; 48 is "0"; and so on.

I did like "feeding an elephant with a teaspoon"!

I like to use a hashed file stage invoking VOC with the Selection tab having @ID = 'VOC', or a sequential file stage accessing a file that is known to exist (such as uvodbc.config) and a filter of head -1.

Partition information will be stored in the design-time information for the input link (in DS_JOBOBJECTS) and in the run-time information (in RT_CONFIGnnnn).

Exactly where in those hashed files I have no idea without looking.

Partition information is NOT stored in the generated OSH.

Use an immediately updated hashed file in the process, to detect whether the record has already been processed (and which will always contain the most recently used value), then Insert or Update into the target. If you prefer, interpose an Aggregator stage to group by key and only deliver the Last r...

Close some of the other Windows you have open and/or add RAM to the client machine.

Within TCL the CHAP (CHAnge Priority) command can be used to lower priority. Usage is CHAP DOWN.

Or you could put a renice command into dsenv controlled by a test on user ID. Process ID and user ID are available from shell veriables $$ and $USER respectively.

Answer this question. Consider row #1 in each of the four files. Will these result in one row or in four rows in the target file? (We really do need to understand what you mean by "merge".)

The site where U is currently working does not use Oracle.

The second person personal pronoun in English is spelled "you", not "u". Please strive for a professional standard of written English on DSXchange, not least to assist those whose first language is not English.

Shouldn't be, except for the standards developed by W3C.

There is also a Find tool (binoculars).

Show us YOUR precise syntax. I, for one, am not prepared to guess what you may or may not have done. It would be a waste of my time. Copy and paste your actual command.

Take an entry-level DataStage class. This will obviate the need for you to ask this kind of question.

Welcome aboard. Scratch disk should always be on the same machine as the DataStage operators are executing - in an SMP environment this is the machine on which DataStage server is installed. Scratch disk is accessed frequently and randomly when it is being accessed. You do not want to introduce netw...

Stages can be contrained to execute in node pools. For example, all stages that write to files might be constrained to execute in a node pool called "export". Similarly, disk pools can be used to constrain other kinds of operation. For example if you create a disk pool called "buffer&...