DSXchange

The weights used to compare against your cutoffs are the totals of the individual match weights for the fields in the (possibly standardized) record, usually termed "aggregate weights". The individual field match weights can be positive or negative, but the aggregate weight is usually positive (othe...

How do I achieve that the job-export file does not only contain the job, but also the job-executable ?
Look about half way down the Export page. There is a selection check box for job executables.

MJC does a lot more communicating with the client (status reporting, mainly) than the CompileAll tool. This probably explains most of the difference; if it could just be left alone to do its work rather than having to give status reports all the time (ever had a boss like that?), MJC would probably ...

I've always thought of it like this.
In any SQL, columns referred to in a WHERE clause refer to the search (constraining, filtering) keys (as opposed to the primary keys).

The Format tab is only for Sequential Files. There is an annotation on the page to this effect.

Welcome aboard! :D This is an all volunteer site. If you want "quickly" sign up for premium support with your support provider. Folks here post when they can. "Best practices" vary with specific requirements. There is (was) an Ascential class called "DataStage Best Practices" that should serve as a ...

You can extend this in lots of ways. For example if the business rules are determined using Boolean functions, the results of these can be combined with AND operators to determine whether the row satisfies all business rules.
But "use stage variables" is sage advice.

I guess what you're asking here is whether dscmdexport.exe is a stand-alone executable, or whether it needs other libraries installed with it. It's certainly the case that you don't need the other clients. As for the first question, why not try it and let us know your results? Or ask your support pr...

Will check with the Parameter Manager dudes. I believe than PM handles Job Activities. If so, that may provide a solution.

Just out of curiosity, do you also have a node pool for sort, as well as a resource pool?
I, too, am interested to know whether this is a Fatal or a Warning, since I always understood that an automatic side effect of Fatal is to abort the job at that point.

It's more a heuristic - by working with a representative sample of data you get the cumulative weights of each record, and inspect the duplicates (XA and DA). The match cutoff sets a threshhold above which the cumulative weight will be understood to be a match. The clerical cutoff sets a threshhold ...

Exactly correct. The APT_CONFIG_FILE environment variable specifies the location of the configuration file to use.

Or even this:
(though it really is easier with a 24-hour clock - change your date picture accordingly).

For entire-key-based lookups a memory-cached hashed file will always be faster than an Oracle table. A disk-based hashed file is possibly still faster than an Oracle table, and definitely if the Oracle instance is on a separate machine from the DataStage server. On the other hand, where you have a s...

I believe the Right() function is more intuitively obvious.