DSXchange

Reset the job and post the entries from "From Previous Run".

Wish you good luck.

Try this.

Very few developers, unless they have a background in UniVerse programming, could have come up with the expression in my previous post.

Very true. That expression was simply great.

Ray,

With my little experience in server jobs i am beginning to feel that server jobs are more powerful in T layer of ETL than parallel jobs. Am i right?

Thanks Craig for your useful alert.

Have two stage variable namely svInd and svCnt. Derivation for svInd If InRec.Col1[1,1]=6 then @TRUE else @FALSE I had assumed that the input is a string. Derivation for svCnt If svInd then svCnt + 1 else svCnt In your output column derivation have the following code: If svInd then svCnt else 1 You ...

Is there any changes to the metadata from input to output?

Shruthi, If this issue is same as your previous thread regarding Join stage then my advice of running in single node is for debug purposes only. I advise you to find the root cause of the problem. It is very difficult for me sitting in a remote location to find an exact cause of your issue. I cannot...

senthilmp wrote:No i dont have indexcon the key column, do you suggest to create one?

Yes.

Did you try using dssearch command?

Do you have an index on the key column? Disabling index in this case will slow down your job.

Try with a single node and verify the results. Is it Same?

Can you embed your design with code tags? Not able to follow your design.

Verify whether the job is in right state to run. Is the job status "Not Compiled"?