DSXchange

The original question is like asking "What can I do to tune my vehicle" in a car forum and can't really be answered, at least directly. Reading and writing data takes a long time. Try to read and write and "land" data to disk as few times as possible. This approach (while not always correct) usually...

The sum of your 10, 25, and 40 do not add up to 100% of the records, so you will be getting less rows than 10%, 25% and 40% of the total. Random number generators are not truly random, the algorithms are designed so that with the same "seed" number they will always generate the same sequence of pseu...

DataStage does not have a scheduler. It uses the default Windows AT or UNIX cron for scheduling.

ray.wurlod wrote:The Hawk release includes some quite impressive estimation tools.

I just walked out of a presentation of Hawk and the estimation tool is for file sizes and disk requirements but not for design effort. It would have been nice to see something like that, though...

This is not an error, but a warning. DataStage is stating that the partitions of the input stream are being changed to just 1 stream because you are writing to a sequential file. This is documented in the Parallel Job Developers Guide.

It isn't worth fixing the DSU.ExecSH until you know if this is the only problem, please do what Ray suggested to see how much might be missing.

You have some internal corruption in your DataStage project that you need to fix before continuing with this job. Start off with the DS.TOOLS and see if the reindexing option shows any errors on any of the internal files.

Changing protection within a project for different cateogries is not part of the normal scope of DataStage. It is better to split this into 2 projects and do the protection at a project level.

The source won't have any rejected records, but when writing to the target in PX you can (in most cases) put a link coming out of the target stage that will contain the rejects. This is documented in the Parallel Job Developer's Guide in the section for the particular database stage.

That error message points to a corrupt project, as that routine is read-only and should always be present. Is this a new project, or has something catastrophic happened to it recently? Look in your Manager -> Routines -> Built-in -> Before/After. Is there a "ExecSH" located there? If you go to TCL o...

Which stage are you using to write to Oracle?

There is no standard, but most character data fields do need to be stored in mixed case and rely on differentiation between upper and lower case. Names, Addresses and clear text become almost unreadable in uppercase; but some key/code/mnemonics columns should be in one case or the other to avoid ina...

Are you sure that your default date format is being used? Execute a SQL "SELECT sysdate from dual;" using your favorite tool and see if that format matches yours.

Katz, the display data mode has always been a bit troublesome and particularly so when working with multibyte data. You should write your data to a sequential file and view the data in the file. I have a suspicion that you settings are being interpreted correctly, but are being shown incorrectly in ...