DSXchange

And what will the parameter file do with the email notification once it receives it?

jprasannakumar wrote:im loading a hash file

No you're not, you're loading a hashed file.

My guess is that you've mishandled the metadata for the hashed file. Hashed files must have a primary key, and fields are accessed by position, rather than by name.

The memory table isn't sorted at all, whether or not the incoming data are sorted. That is, no sorting is applied. Indeed, what's built in memory is a hash table (not the same thing as a hashed file).

The MKS Toolkit C++ compiler is not supported. You need to install the correct compiler before installing DataStage server. Search the forum for details.

The file that could not be found ('D:/PROGRA~1/MKSTOO~1/etc/cxx.ccg') is part of MKS Toolkit.

First please make clear whether this is a server job question (as marked) or a parallel job question (as per the forum in which you have posted). The answer will be markedly different based on job type. If it's in a job sequence, let us know that too.

Can you show us how you're trying to use DSSetVar? And where?

The correct spelling of the second person personal pronoun is "you" not "u".


You can use any method you like to sort the data. A Sort stage is one way. If the source is a database table, you could include an ORDER BY clause in the extraction SQL.

It's not about UNIX permissions, it's about table privileges within Teradata. The first developer, creating the table, becomes its owner and has all privileges. The second developer has none, because neither the first developer nor the DBA granted any. Usually, when you create a table via an ETL too...

umamahes wrote:I can write a routine to create a list of jobs in a category.

Apparently there is. Care to share it?

svContainsSep <-- Index(InLink.TheColumn, "--", 1) If svContainsSep Then Field(InLink.TheColumn, "-", 1, 1) Else InLink.TheColumn If svContainsSep Then Field(InLink.TheColumn, "-", 3, 99) Else 0 It's not totally clear from your examples what your business rules ar...

Not the case, Arnd. The server Aggregator stage builds a dynamic table in memory, with one row for each combination of grouping keys. The initial size and increment of this table is tuneable using the final option on DS.TOOLS menu. With unsorted data, the entire input stream must be loaded into this...

Yes, you need to define within ProfileStage where the Analysis Server is (or even multiple Analysis Servers). When you open ProfileStage's Connection Manager you identify not only the PSDB but also the Analysis Server(s) as well as any associated data sources and details. The first time you access a...

Lose the ftp:// prefix.

That's why I asked you to check whether the view was partitioned. It is not necessarily the case that a view on partitioned table(s) is itself partitioned. Here it is not. Present your findings to the DBA to confirm. Meanwhile, remove the view name from the Partition Table field. Possibly replace it...