DSXchange

ray.wurlod

Moderator: please move to parallel forum

Version 7.5x2 is NOT supported on Windows XP for the server component and never will be. However, it does work.

The same is true of version 8.0 and 8.1.

ray.wurlod

I'm confused here. A hashed file MUST have at least one key column. In the Transformer stage you set up a key expression that generates a value that is looked up. Order of key columns in the hashed file is vital. Order of non-key columns is not, provided that the metadata have been handled rigorousl...

ray.wurlod

But it will not preserve the original rows. This design will. Filter on count < 4.

Code: Select all

source --->  Copy  --->  Join  --->  Filter  --->  target
               |           ^
               |           |
               +-->  Aggregator

ray.wurlod

Please mark thread as Resolved using the green button at top.

ray.wurlod

Code 2 usually means "not found". Can you provide more details? What's the name of the routine, was it compiled/linked correctly, is the parallel routine definition correct (particularly correct number and type of arguments), did the routine name used in the job correspond with that of the...

ray.wurlod

... until and unless a log purge has been performed. That's why people build systems like ETLstats...

ray.wurlod

There are myriad possibilities, all described in a document created by Ascential support and available through your support provider. DSN technically is only for ODBC.

ray.wurlod

U is one of our posters and is currently working on a server-only project. The second person personal pronoun in English is spelled "you", not "u". And the present tense of the verb "to be" in the second person is spelled "are", not "r". Please stri...

ray.wurlod

The SAP R/3 Extract Stage can generate ABAP code. If you modify the stage properties appropriately, the ABAP code is changed.

ray.wurlod

What is the value of your TEMP environment variable, if indeed it is set at all?

ray.wurlod

Status 2 is "file not found". Please check the correct spelling and casing of the file name - file names on UNIX are case-sensitive.

ray.wurlod

Please delete your duplicate post on this before anyone responds to it.

ray.wurlod

Each is an executing process. Every operator runs osh, every section leader and conductor process runs osh. A parallel job executing in an N-node configuration has one conductor, N section leaders and N player processes per operator. They should go away automatically, particularly if the conductor p...

ray.wurlod

The most efficient way, in this particular case, is to use Convert() function to change the "-" characters to "".

Code: Select all

Convert("-", "", InLink.TheDate)

ray.wurlod

I agree with Mike.

It may be easier to do in parallel jobs, by converting the metadata into a schema file, but it would still be brittle - what happens when you need to refer to some dynamically-created column name in an expression?

Search found 53125 matches