DSXchange

Keep in mind the Compare() function. You can force string comparison. There is no practical limit to the length of a character string value in DataStage, and that includes as the value of a stage variable. Finally, you don't need If expression Then @TRUE Else @FALSE; any expression that uses a compa...

It's perfectly OK to have more, or even fewer, columns in the target than in source. If you don't want to load the other 8 columns in this job, you can omit them completely from the job design that inserts the rows (provided the omitted columns are equipped with suitable default values in the table ...

This set me to wondering whether anyone has written anything on all the various cases/scenarios of maintaining an automobile, what are the possible cases (what are all the things that could go wrong) and solutions that could be done? Or perhaps the same on medical care and maintenance of the human b...

There's no "." in SETFILE. You may have created something called a "Q" pointer in your VOC file. More on that later. You can delete the hashed file, if there is no VOC entry, using DOS /C "DEL /S/Q D:\Hashfiles\hash_POLIZZ1" DOS /C "DEL /S/Q D:\Hashfiles\D_hash_POLIZZ1" The SET.F...

Check your configuration file.

The reported error is "a node of the producing operator, ccsidbu1,
has no disks in the default disk pool".

Does this coincide with that your configuration file specifies?

This is an Oracle error, not a DataStage error.

Something in your design, or something else that is running on Oracle at the same as your DataStage job, is causing a deadlock situation. For example, are you trying to update the same table that you're selecting rows from?

To be pedantic for a moment (who, me?), it's not really RTI. Quality Stage has its own "real time manager" (runs as qsrtmngr) which only DataStage uses. It's that to which I referred. (Incidentally, it works well straight out of the box if one follows the instructions accurately). If you want to exp...

Are you beginning to suspect that the file definition does not match the data? There are certainly more than two characters preceding the 15 digit number!

Where do you get 95 from? The addresses down the left are still in hex, and I observe that 0x92 (the end of the first record) is 146 in decimal.

Sorry I can't help with the rest of it just now; deadlines loom!

Disk space. Allow at least ten times the disk space as your data volumes suggest. We kept blowing disk space (have now added 200GB more with another 1TB soon to be delivered).
QualityStage keeps all its intermediate results on disk, and all its reports on disk. It needs a lot of disk.

QualityStage with the Real Time Manager comes pretty close to "true" client/server, however.
Currently setting up just such an animal.

Consult your planning (source to target mapping or target from source mapping) document. You DO have a plan, don't you? Based on the business rules specified in this plan, fill in derivation expressions for each of the 25 target columns. They may be based on any combination of input column values, s...

APT_RECORD_COUNTS and the other APT... environment variables apply only to parallel jobs. They will have no effect at all on server jobs.

You could use QualityStage to perform your de-dup operation. Call it from the QualityStage plug-in. Simply stream the file in to this stage, and receive back the de-dup'ed file for ongoing processing.

Yesterday I wrote a sequential file 13,193,827,815 bytes in size using the Sequential File stage.

Did you run out of disk space?

The only limit I'm aware of is the operating system limit (whatever that is; 2GB on some, 1TB on some, 19 million TB (theoretically) on some).