DSXchange

Submit an enhancement request to get the stageinfo functionality to work with Data Set stage. Currently is doesn't, which most regard as a bug or at least a deficiency. Hey, it may already be fixed - check on Fix Central.

A parallel job can, of course, use a text file as a source for a reference lookup.

You need 8.1.2 or the Exception Manager. I haven't had a chance to play with it yet, but reading the manuals for it is on my plate for this week.

Add reject link to Oracle Enterprise stage.

Use Copy stage to create the two streams. Use Join stage to rejoin them.

You can use BASIC Transformer stage. You DO have access to it. It is in the Stage Types folder in your repository. In parallel jobs, reject handling is more typically handled in the database stage, rather than in a Transformer stage. For example, a reject link from an Oracle Enterprise stage will au...

Do not pre-load to memory. You want to be able to write to the hashed file as the job runs. Likewise to not enable write cache. You want to be able to ensure that a record written is immediately available when the next row is processed.

You'd think scribd would have posted the version 7.5 manuals at least!

Then again, the very publishing of them violates copyright in every conceivable way.

I can't remember. Have you tried it? With what result?

Remove Duplicates stage.

Make sure that caching is disabled in both stages, and that the writing Hashed File stage is set to "lock for update".

You may find a more meaningful error message in the node agent log.

Wrap your design in Code tags so we can see what connects to what.

Without that there's not much sense in trying to essay an answer.

The usual solution for SCD2 in server jobs involves two Hashed File stages referring to the same hashed file.

The CHAR types in the database may contain trailing space characters. Simply reading these as VARCHAR will not trim these spaces - you have to use an explicit function, either in the SQL or in the job.

Use the logic of the MONTH.LAST Transform to get the final day of the current month, add one to the internal format then, if necessary, convert to external format.