DSXchange

SURA means that both inputs should be identically hash partitioned. You can't prevent the alert about being unable to use shared memory; this can legitimately demoted with a message handler.

Project names are case sensitive. Is it possible that your project name is actually "Default" or "DEFAULT"?

What are you getting and what do you expect to get?

It definitely has to do with the "Metadata and" piece. This tool can move metadata into and out of the common metadata repository, which Metadata Workbench is, essentially, the query tool for.

In version 8.5 is there any way to prevent the password from appearing on the istool command line when exporting DataStage components? (In version 8.7 the -authfile option is available and/or command line passwords can be encrypted, but I'm asking about 8.5. I don't have an 8.5 system on which to ex...

1. Process the maximum possible number of fields and output only if the result is non-empty.

2. Use a server job and take advantage of the dynamic normalization characteristic of hashed file or UniVerse table.

3. Upgrade to version 8.5 or later.

Oracle is using three bytes to store each character when "NLS" is enabled. Depending on the region it can even be four. You have two choices - either to have the metadata in DataStage as imported (that is three times the "characters" length), or define your Oracle columns as CHAR...

Assuming you're on version 8.5 or later, use a loop in the Transformer stage to output a row for each "+"-delimited field in the ATTRIBUTE_VALUE_4 column.

Welcome aboard. The AMERICAN_AMERICA.AL32UTF8 character map clearly does not handle Cyrillic characters, because "written American" (if I may use that description) does not use them. You need to specify a map that can handle Russian characters. Every map includes ASCII characters, so all y...

During the import you have two options; Import All and Import Selected. The latter reads the export file and displays its contents on screen; this report also shows which objects already exist in the target project. From here you can select just the objects that you wish to import.

Is there any way that I can import this metadata directly into datastage without manually entering all the 300 cols. Possibly, possibly not. If what you're seeking is something that will read a file of column names and start and end positions, and convert that into a DataStage table definition, the...

Looks like your metadata specifies 982 characters in a line but the file has more - maybe 983. Might it be the case that your metadata specifies UNIX-style line terminators but the file actually has DOS-style line terminators?

Are the VARCHAR2 or CHAR column lengths defined in terms of BYTES or CHARACTERS ?

There are two questions, and it's not clear which one you're asking. What are the names of the jobs that are designed into a sequence (whether or not they are actually run when the sequence executes? What are the names of the jobs that are actually executed by a particular run of the sequence? These...

Find the install.log file.