DSXchange

Hi, I have a change capture job where i'm comparing data from a parallel job output to a server job output. These data are supposed to match. Every other filed in the data matches perfectly but I have a problem with this one field whose data looks like : 0000050100805721 3437 1 0000059500560060 W 02...

Thanx a ton.. DSguru, we are currently working on the issue .. I will try and let you know if anything works.

@DSguru

I created a routine like u said and it works in a PX job... I really dont understand why the original dosent work ??

DSguru , you said that you posted a routine dealing with ascii values ..... can you point me to it ?

I got the source as varchar, trimmed and specified the routine and i specified the output format as "CHAR". This did not work.

Could there be any other problem?... plz help

Ok , i will convert to varchar and try. But the routine is written in such a way that it works with data that has spaces too, as you can see in the picture above... it leaves spaces as spaces.

I will try and let you know .... thanx

@ DSguru The same column from the same source is been used in a server job and the routine works for it. i am comparing my parallel output with that server output to check if the routine is working. My datatype is char, and yes i am trimming the values. @ SUD How can i find out if i am on a SMP syst...

<img src="http://img15.imgspot.com/u/07/59/19/unt ... 794506.JPG">


Thats the test output for the routine

There are no warning in the log file ..

Yes the routine works, I have tested it and it is also been used in other server jobs. But this is a totally different scenario.... basic transformer in a parallel job

Ans = "" FOR I = 1 to LEN (InputString) ASCIICode = Seq(InputString[I,1]) IF ASCIICode >= 32 AND ASCIICode <= 122 AND ASCIICode <> 91 AND ASCIICode <> 93 AND ASCIICode <> 94 THEN Ans = Ans : InputString[I,1] NEXT I Thats the code for the routine, I need to get this routine working in the ...

The routine is written to strip off some unwanted characters which are present in a given column. But when i run the job the routine does not remove the characters, they are still there.

Hi,

I am using a Basic transformer in a parallel job, can I use a server routine in that transformer ?. I am trying to do it and is is not working.

thanks

@us1aslam1us

Thanks ... that clears my mind about the partitioning.

About the warnings , I did try turning RCP off .. It dosent work, but if I specify all the columns as values or keys ...I shud not get the errors, this happened to me a few times.

Is "HASH" the right option for sorting, does it effect the data in anyway?

@us1aslam1us "Clear Partition" dosent improve the situation but I have another question. I have 1187000 rows in the "before" data and 1188000 rows in the "after" data Does this effect the change capture process?. It should show the 1187000 rows present in both the files...