DSXchange

New data files as well as a new descriptor file.

The data file names include the name of the associated descriptor file.

pandujoy wrote:we have to use only parallel jobs....

So how come you posted in the Server Edition forum?

Moderator: please move to Enterprise Edition forum

Resist stupid requirements!

Welcome aboard. Those characters are not "special" really - you just have to set up DataStage to handle them. Typically this involves choosing the correct character map. Search DSXchange for NLS or, if you wish special character to learn how others have solved this "problem".

Is ADDRESS a rule set that you (or someone at your site) has created? It is not the name of a rule set that ships with QualityStage.

Please show us a description of your job design, in particular the stage types used.

Welcome aboard. Please help us to help you. What is your job doing? In particular, what Rule Set are you using in the Standardization stage? Has this Rule Set been customized in any way, especially in the Pattern Action Language file? How many overrides are in place? Without those kinds of answers t...

It's not a good representation. Please enclose it in Code tags and preview/edit until the alignment is correct so that we can properly understand what you have designed.

Incidentally, a Sequencer is a component that you use in a Sequence.

Use a phonetic equivalent (e.g. NYSIIS of FirstName) as the blocking column. This will allow for slight misspellings when you match on FirstName. Depending on your data volume and value frequencies, FirstName alone may cause block sizes to be larger than one might like - you may benefit from investi...

I would certainly say so (precluding any bugs, of which there were some in version 8.0). Try it, and let us know.

Provided that it's not re-initialized, a state file will always yield unique key value(s).

A sequential number can only be guaranteed with sequential mode operation. "They" can have what they want, provided they don't also want minimum execution time.

Probably rounding when converting from dfloat to decimal. Remember that dfloat can not be accurately stored.

If you want accurate, consistent results, use the Preserve Type option (if using version 8.1).

But DS_AUDIT does not record logins. And, at 8.1, it appears that DS_AUDIT is not correctly recording object class.

What happens if you convert each to Decimal first? Use DecimalToDecimal() function.

The Director client does not quite display everything in the job log. Actually, it does, but the rightmost column has a display width of zero - you can open it by dragging the column boundary in the grid header.

If not that, what information do you believe to be "missing"?

There is no command line interface to toggle the protected status of a project. (You can prove this to your own satisfaction by enabling server side tracing while toggling the project status. It makes calls to various DataStage helper subroutines. These, in turn, (in version 8.0 and later) invoke ap...