DSXchange

Tell us also what you mean by "filter option". The Filter stage certainly works on Windows, but I don't think this is what you're getting at.

Not in the Lookup stage, but you can in a downstream Transformer stage. Remember the philosophy "one task, one stage type". Lookup stages do lookups. That's all.

You should not be doing this as the job runs, you should get the link row counts after the job has finished. Do this in an after-job subroutine or in an external routine (possibly invoked from the controlling sequence). Either of these uses the DataStage BASIC language.

Try it.

Many mail viewers will automatically convert a URL into a hyperlink.

Download ETLstats (free) from Kim Duke's web site rather than re-invent the wheel.

Propagate is advisory (Set is mandatory). So, with Propagate, you will be able to re-partition downstream. One occasion where it is desirable to do so is where the downstream stage executes sequentially (and so can not preserve partitioning). You set Preserve Partitioning to Clear in this case to pr...

Depends on how you calculate update_date_time. To get it the same for all records, initialize a stage variable in a Transformer stage with the current timedate, do not provide a derivation expression for the stage variable, and use the stage variable in the output column derivation of update_date_ti...

What changed three days back? "Nothing" is not the correct answer.

There are no datatypes. So...

If you attend the IBM class Advanced QualityStage (DX746) you will create a Rule Set for "part names", even though they're foodstuff parts.

Note too that DS_RESENU does not need to be replaced. This is not the hashed file that has the problem.

Why bother? In a Transformer stage you can use @INROWNUM or @OUTROWNUM to give the row counts.

Try disabling Balanced Optimization, at least for a test.

You may find that @YEAR and @MONTH system variables are available so that you don't need to use Oconv() at all.

Windows XP is not a supported platform for the engine, services or repository tiers.