DSXchange

A Copy stage that makes a single copy of its input will be optimized out of the design. A Copy stage that has no output will consume all of its input at no cost. So, if you remove the stage downstream of the Copy stage but leave the Copy stage in place, there will be no performance penalty.

You'll probably spend more writing and testing your own data masking routines, test data management systems (you need to preserve relationships between tables) and control systems than you would to purchase Optim.

Is there anything useful in the SystemOut.log for the WebSphere Application Server?

OK, I now see the bigger picture. Still don't like your chances of getting this one through (it can be done in a sequence) but, if you don't ask you might die wondering!

My initial thought is that the Optim product from IBM does all this and more.

Ah. I suspect IBM's response will be that you can use stage variables in a Transformer stage early in the job to effect what you describe as "computed parameters" - simply putting these values onto an output link makes them accessible downstream. A stage variable that has an initialization...

The inner set of parentheses is not actually necessary; I included it for clarity.

If you're looking for a command line based approach, search for dsjob command.

Please respond on this post!!! We must have our questions answered.

At a guess, the jar file needed by the stage is not in your CLASSPATH. Unfortunately I do not know which jar file the stage uses.

Or use a lookup table in a Modify stage (lookup_string_from_int16() function).

PII ? We have no idea what "data scrubbing" means in your context. You need to begin with a written specification of what you need to achieve. Without that no-one would be able to help you. It is also unreasonable to demand answers here, particularly so soon after posting on a weekend. DSX...

kerpal_dog wrote:Tried setting the APT_AUTO_TRANSPORT_BLOCK_SIZE to True (as per documentation suggestion) and same old stuff.

That can't be right - it would give you a block size of 1, where you really need it to me much higher, maybe 1MB or more.

The dot can matter, as a reading of the man page for source will reveal.

Allow the mail to go through the gateway on your internal mail server.