String maths

robvonk · Post by **robvonk** » Wed Aug 22, 2007 7:30 am

asitagrawal wrote:smat.exe is available in ..\Ascential\DataStage\Engine\Bin\

I'm a developer and have no access to the server.. I'm affraid i can't help you with smat output.

Do you really need the SSUB for comparing? Are the numbers that large?

asitagrawal · Post by **asitagrawal** » Wed Aug 22, 2007 7:46 am

robvonk wrote:
asitagrawal wrote: Do you really need the SSUB for comparing? Are the numbers that large?

yes, the numbers are big enough that I need to switch to string mathematics ...

I dont know what to do now...

robvonk · Post by **robvonk** » Wed Aug 22, 2007 8:44 am

If it's only to see if there are differences:

Cut the string in pieces.

Code: Select all

For example:


123456|789.12 vs 6|789.01

| = cut point

12345 is larger than 6 so you have a difference

No need to check the rest

123456|789.12
123456|789.01

| = cut point

123456 = 123456

compare 789.12 with 789.01 normal substract

This should be doable in a routine.

asitagrawal · Post by **asitagrawal** » Wed Aug 22, 2007 8:57 am

Yes, I agree... i.e some workaround approach , like the one you are suggesting , is possible... but the problem is that I would need to invoke a routine for each of the input record...

I am processing close to 20 - 30 Million records and for each invoking such a routine... I dont know how DataStage will behave... I mean performance wise...