The worlds smallest hooray for our upgrade from Informatica 5 to the latest version 7. Apparantly in version 5 when some numeric fields where contaminated with non-numerics, they were just being set to zero. Version 7 correctly rejects these rows, thus revealing a problem with one of our source data feeds. Looks like some of the columns sometimes get shifted over.
Informatica is not-so-good at dealing with such an oddity, although to be fair I suppose that if a file is suypposed to be “fixed width” then the very least that you could expect of it is that it’s widths would be in some way “fixed”.
I guess that we’ll probably apply some kind of “preprocessing” script to the raw data files to detect, correct, and log the problem.
I’m a little startled to find that an upgrade to 10g is suddenly a possibility/probability. This brings to mind the saying about being careful what you wish for, ‘cos my mental (at the moment) list of things to be be done is stretching out towards the distant horizon.