DSXchange

Parallel. StripWhiteSpace() is not available in server Transformer stage.

Visit the stage properties of the Transformer stage and tell us whether its Propagate property is set to Set, Clear or Default. It's on the Advanced tab. And, if it's not Clear, then your code reviewer is wrong, wrong, wrong. You can prove this by inspecting the score. As to question 2, if the parti...

Bicchu wrote:Hi All, I need this clarification from all of you.

So, you want 38309 replies. Is this correct?

You ultimately do need a consistent date format, so there's probably not much more you could do. Perhaps losing the If test would be slightly more efficient, for example on the reference link

What (if anything) have you specified as the repetition element?

James beat me to it. Just occasionally I have to work for a living and ignore DSXchange for a few minutes!

I won't be running it this year. However other organizations have, and maybe will be. However, this is not under my control - I merely license the materials to them, as registered training providers. Contact me off line for more information on which organizations these are.

It will, because it needs direct access to the server engine.

Exclude them from what? What are you trying to accomplish?

Do the inserted rows include a run identifier? If so, a second job that counts those rows would do it for you.

Yes, but only manually.

This is a lab exercise in my Advanced Parallel Job Techniques course.

Update is always slow because of the extra work it has to do. Is every column in the WHERE clause supported by an index? Is the index being used?

One.

Of course you can have more than one running simultaneously, but your question was specifically how many can be started at the same time.

The limit is governed entirely by the resources available on your system, and is almost certainly less than you are hoping for.

You need to configure the shared library search path environment variable (LD_LIBRARY_PATH).

Default Lookup will work like left outer join (using Continue rule) or inner join (using Drop rule). It can not perform full outer join.