Page 2 of 2
Posted: Wed Aug 22, 2007 7:30 am
by robvonk
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?
Posted: Wed Aug 22, 2007 7:46 am
by asitagrawal
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...
Posted: Wed Aug 22, 2007 8:44 am
by robvonk
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.
Posted: Wed Aug 22, 2007 8:57 am
by asitagrawal
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...