DSXchange

Do you have many unbounded VarChar data types inthe record? What is the speed if you use this design as a test?

Don't worry about counting anything. Specify two readers per node to read the file. DataStage will work out the 50% point automatically.

This is a fairly typical "fork join" design with one tine of the fork calculating the count.

When is the interview?

Sort by transaction date in ascending order, then use Remove Duplicates stage to preserve the last from each group. (I'm assuming a maximum of two rows per group.)

Weak advice - the conversion function will fail if the string is not a valid timestamp. The IsValid() function is intended to be applied to a string.

WHAT error occurs? (Without that information your question is in the "my car won't start" class.)

On some UNIX servers, anyway. Sometimes it's /etc/rc2.d, sometimes it's called rc.d.

Somewhere, somehow, you are going to have to classify some names as first names. You probably also need to parse the pattern + | I | + into first name, middle name and primary name buckets.

This is not a QualityStage question.

**Note - topic relocated by Content Editor **

It's "sequence", people, not "sequencer".

A sequencer is something you might use in a sequence.

Why would you want to?

Even easier, use Modulus partitioning on a two-node configuration (or node pool) and have the Sequential File stage write two files.

2003 or 2005 only.

You can Search DSXchange for clues on where to find these for download.

Try putting a short pause - maybe 30 seconds - between the finish of one export and the start of the next.

Parse into separate columns (Transformer stage) then use a Pivot stage. DSXchange is an all volunteer site whose members post as and when they can. It is not a substitute for official support and, particularly, nothing here is urgent. We regard terms like "asap" to be offensive. If you wan...