DSXchange

hellboy wrote:Could you please tell us how it is possible in Server job....?

Server job questions really belong in the server job forum.

This helps future searchers.

:D

What warnings are these?

Do you have a NOWARN specification in your Modify stage? (These are really about nullability warnings, so I doubt that they'd be legitimate here.)

Is there any reason you can't use NVarChar(8) as the input data type - possibly derived upstream using a substring operation?

What stage type is downstream of the Merge stage, and is it executing in sequential or parallel mode? Does your Merge stage have a reject link and is it capturing any rows? One possibility is that you are trying to match the same key value three times, but are not aware that rows from the update inp...

U is not posting in this forum today. And certainly not in this thread. (Though I note that U has made a post today.) The second person personal pronoun in English is spelled "you". DSXchange is not a mobile telephone nor is there any requirement to limit your messages to 72 or 144 charact...

Welcome aboard.

You have posted your question (incorrectly) in a forum designed for people who wish to say nice things about DSXchange.

You are more likely to get a cogent response if you post in the appropriate forum, in this case the Enterprise Edition (parallel) forum.

DS_AUDIT seems to be being maintained in version 8 also, though recording of CLASS cannot be relied upon.

You will see references to individual parameters, whether or not they reside in Parameter Sets, in a Job Activity, and could therefore replace the default value of an individual parameter in that interface. Or you can completely overwrite the values file, or even create a new values file, and set th...

Note that the final eight characters of the table name will differ in your case; it is tied to your licence, not Joshy's.

The function is decimal_from_ustring but, like Craig, I am puzzled about precision 120 on a decimal field.

The Join stage mandates sorted input, therefore the option of "without sort" is moot.

I prefer to use the Sort stage to using input link sorting, because there is greater control and flexibility over resource usage.

If the load on the database server is light then use DISTINCT in your extraction query.

If the load on the DataStage server is light and you don't need to specify first or last from each group, use a Sort stage (you can control allocation of memory using the stage rather than a link sort).

What is your "unmatched masters" rule?

Even that may be in parallel.

You need a single File property and a Filter Command to cat the three files together.

I will be presenting a paper on QualityStage Rule Sets at IOD EMEA 2010 in Rome in May (and at IOD 2010 in Las Vegas in October if it's accepted).