DSXchange

ray.wurlod

Do you really need the count as a separate operation? Why not calculate it as you are processing the actual file?

ray.wurlod

And have you set up this column on the output link?

ray.wurlod

Thank you Sir, It worked. Such a small thing and it created a havoc. Can you explain me what's the difference in writing Trim(Variable[from,len]) and Trim(Variable)[from,len]. The obvious difference is where Variable contains leading trimmable characters. The first syntax strips the first len chara...

ray.wurlod

More is better.

ray.wurlod

Relying on auto-create will prove counterproductive if the job design reads from and writes to the same hashed file.

ray.wurlod

Avoid per-column mapping if you can - this is only needed where different columns are encoded differently, and it slows down processing hugely.

ray.wurlod

... but most of the content is protected. Premium membership is not expensive, at less than 30c (Rs12) per day. Once you have it you can, among other things, read the entire contents of premium posts. You also get discounts on DSXchange offerings (such as training materials) and special access such...

ray.wurlod

Are you using inter-process row buffering to leverage multiple processes (assuming that you have more than one active stage)? Have you considered using multiple instances of the job each processing a distinct subset of the data, but running in parallel (assuming that you have spare resources)? Are y...

ray.wurlod

$PROJDEF works properly (does not need to be overridden) in version 8.1.

I have not yet tried to specify $PROJDEF as a default value for an environment variable parameter in a values file, but see no reason that it would not work.

ray.wurlod

Advise the data types of all the fields mentioned in the expression. Without that we can't really help.

ray.wurlod

Only one append is permitted in any one job, apparently.

ray.wurlod

Yes but that would take longer and introduce dependencies that don't actually exist, e.g. H depending on A.

Code: Select all

A --+
    |
B --+
    |                        --> J
C --+--> F --> G --> H --> I --> K
    |                        --> L
D --+
    |
E --+

ray.wurlod

To be visible in the Transformer stage expression editor, the routine must be of type "transform function".

To be visible in the Transformer stage before-stage or after-stage subroutine field, the routine must be of type "before/after subroutine.

ray.wurlod

Server jobs do not enforce data types so you can simply get the leftmost 10 characters.

Code: Select all

Left(InLink.TheTimestamp,10)

ray.wurlod

Load it into an upstream user variable and trim the line terminator from it there.

DSXchange

Search found 53125 matches

Re: Appending to a Sequential File using Seek