DSXchange

Kim, I'm not sure that is a viable option any longer. With version 9.1 I tried putting the dsjob executable on an Informatica server so that "they" could use it to run some remote QualityStage jobs. dsjob had so many hooks into the services tier that I finally gave up and had them ssh into...

I don't think there is much you can accomplish with the job design... it sounds like you're already taking advantage of the connector's bulk read capability.

An investment in faster network and faster disk might be necessary...

Mike

Go to a command prompt and ping your host. If the host name can not be resolved, add an entry to your hosts file.

Mike

XXX-COLUMN PIC S9(09)V99 BINARY It looks like DataStage has taken BINARY to mean COMP in this instance, which is most likely not what is needed. DataStage takes COMP to mean a binary integer which then means the implied decimal and 2-digit scale are meaningless. You seem to have gotten an int64 (Bi...

I agree support is probably going to be the best bet to help you track down what changed or what is inconsistent.

When did you do the AIX upgrade from 5.3 to 6.1?

Your original post seemed to show a compiler for 6.1, but your last post makes it look like a compiler for 5.3.

Mike

Try this command: If it is an expired trial version, I think that command would report it.

Though if it is an expired license, I think your hello world program wouldn't compile either.

Mike

Once we did force compile, we cannot able to compile any parallel job with Transformer This essentially means that you have never been able to compile any job containing a transformer with your current configuration. Existing compiled transformers only get recompiled when necessary unless you speci...

XL C/C++ for AIX, V11.1 would be a supported compiler on AIX for version 8.5. Question: Can you force compile an existing job with a transformer stage? What are your settings in these project environment variables? $APT_COMPILER $APT_COMPILEOPT $APT_LINKER $APT_LINKOPT Maybe someone at an AIX site c...

Note that if you open it as text on a Windows box, you won't be able to cut & paste it.

Open it as binary on a Windows box with a text editor that supports binary.

Mike

013 is the decimal value of that single ASCII character. The easiest way to put that single character into the stage property is to cut & paste it from a text editor. It'll probably show as a box once pasted, but should work fine. You can also try choosing whitespace as the final delimiter since...

Ok. Thanks for clarifying. With a write method of insert, you'll be using transactions and everything Ray and Craig have suggested would apply.

Mike

Does your selected method/write mode support transactions?

Many bulk loaders don't.

My Oracle usage is too rusty to remember SQL*Loader options.

Mike

The metadata for the select from your view would be checked before execution... at which time your view does not exist. I agree with Craig... Before SQL is not the place for this view creation. Is there a reason for creating the view for every job run instead of a one time creation? If yes, I'd prob...

Simple answer is no. Substitution is done in a single pass.

Mike

I suggest investing as little effort as possible in managing workload in version 8.7.

When you upgrade to version 9.1 or later, workload management is part of the infrastructure and there is no longer a need to manage it within your application.

Mike