DSXchange

you should post all the error messages you are getting when the job aborts.

DataStage Developer

Won't it save on developers time, increasing productivity, and lower turn around time, if you get a ready made plug and play thingy. Time is money my friend. :lol

chulett wrote: Now what they don't have is one for Informatica.

You can have that created easily, just add keywords in C1, C2, C3 tags and you are done. Just need to make sure its sorted (or that may not be a requirement anymore).

Can't check GUI but there should be a number to limit the number of loops. In your case, How many time you want the loop to run in-case it encounters a negative value? That being said, I would handle it in a case statement for 0 or -ve values for deciding on the number loops.

That is a Yes. And keep clob as last column.

We "almost" always do some sanity check or reconciliation at the end of load for some key values. counts amounts for critical information. I prefer to know if there is a problem before business lads finding and start screaming. However I keep such sanity checks precise and minimum, limited...

Open table metadata in developer and click on parallel radio button.

Well, there is some gap in your understanding. 19982.2776 is rounded to 19982.28 as 76 is more than 50 19982.2776 is floored to 19982.27 and -19982.2776 will be floored to -19982.28 and similarly -19982.2876 will be ceiled to -19982.287 and +19982.2876 will be ceiled to +19982.289 if you can't make ...

Loop variable was introduced in 8.5, so no looping in 8.1 I guess. I would simply vertical pivot, join and then aggregate. Or split in different columns and do multiple lookups if number of components are low and finite.

Installation on SAN is good but on NAS may not be a good idea. Top level mounts are ok but separate mounts for resource scratch may be better. And From my experience minimum of 0.5x of swap space is required, 2x recommended. Its my opinion, which may differ for 11.5 (haven't worked on that) or someo...

You forgot to set project.msh as project level message handler in administrator. However, you listed out the steps correctly, if that's what you wish to achieve. I for an instance do not prefer to have a message handler, if I do, It is project specific where I know the reason for suppressing the war...

Can you post exact error message in question?

And then a couple of questions.
Did you install oracle client after datastage? did it ever work on that system?

The first thing I would look at the change in number of nodes and then if the operator combination was disabled (environment variable APT_DISABLE_OPERATOR_COMBINATION or some thing similar). Port or Authentication wouldn't be the first place to look for in this case. Or may be changes in schedule of...

you may need to re-register the OCX mentioned in the error. Else do a clean install after un-installing and deleting the relevant registry entries.

You can refer the step (not for the same issue) here