DSXchange

There are ways to compare the current and previous data. ChanegCapture stage, or Join-Transformer Combination will help you. But what is the requirement after getting the detail about, update and new. Is it you want to update the existing record with the new records or you need to insert with an ind...

Is you Script executing from command line?

PadString() will do for PX.

May I know what is the version of the unix.
Each flavour will have its own parameter setting. Speak to your Unix SA.
It can deal with seting up the parameters like maxuprc, nkthread, max_nprocs or nproc...

Should the row buffer be disabled for this?

While installation, you would be asked for Server as well as PX keys.
If you fail to feed in Server Keys, you wont be able to access it.

But you can do the two lookup in the same transformer. By just having nested If - then - Else condition in the derivation. Have one link from the transformer with NOTFOUND for the first lookup as the constraint, and in derivation part check for second lookup match, and assign the value and store it ...

i noticed that there was no change in the usage of the above disks

Since all your existing dataset are getting overwritten with the new set, you may not see the remarkable difference.

I am not able to implement this using a DB2 Stage

What is the problem you faced while implementing it?
Is it you have row level commit?

What is the maximum consumption of the memory for the temp dir, while all the 30 jobs runnign simulteneously? BTW: By any chance, your job design has a some link gets partitioned from a single source and gets joined up again? Fork erro prompts me to ask this one... It seems it is not only the memory...

ArndW wrote:You will need to recompile jobs that use a transform stage.

ArndW - Do you mean Basic Transformer?

It should run well. The other problem I faced is, the parameter values in version 7.5.1a. Though the parameters been passed new set of values, it some how gets the values passed early. Recompilation worked. And regarding the compiler, if you issue the compiled code from one server, it is not madator...

Perhaps it can be moved to General Forum. Usually HP proclaim that DataStage is optimized for HP m. May be from next release of Hawk, AIX should proclaim for DataStage , HP for Informatica (As per the stats given in the page) Btw: FireFox grabbed the page quickly for me. May be Iam in Newer version.

Kim - Make the Shiny T-Shirts available soon. :D

Sorry, I missed. I was about to say Oracle stage to dataset.
And what is the data type of the column, on which datastage complaints.