.comment-link {margin-left:.6em;}

Oracle Sponge -- Now Moved To Wordpress

Please use http://oraclesponge.wordpress.com

Wednesday, April 20, 2005

Upgrade News

Informatica

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.

Oracle

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.

4 Comments:

At 9:14 AM, Blogger Pete_S said...

Make me glad we rolled our own in OWB ;-) - oh and Mercator for one customer

10g - is that certified for Business Objects yet? - one of my customers is locked into 9 until those French guys will provide support. But 10 is fun

 
At 9:33 AM, Blogger David Aldridge said...

Well that's a good question, and it probably depends on whether you're talking about the repository or the warehouse itself.

I have some other concerns about RMAN as well -- the folks who rovide some of our more basic DBA services (eg. B&R) are about to go to RMAN (finally), and I'm wondering whether this is going to cause a problem there as well. Historically our system has tended to be at the cutting edge within the organization, but hopefully this isn't going to push them too far.

 
At 10:04 AM, Blogger Pete_S said...

RMAN, what luxury... we had a hardware vendor get to one customer before we did - their backup is flash copy 2.8 TB of DWH to another set of disks on the SAN and back that to tape each day.... they should have given the money to me!

 
At 10:18 AM, Blogger David Aldridge said...

Lovely -- we just managed to put an end to weekly exports of our complete warehouse. Extraordinary.

 

Post a Comment

Links to this post:

Create a Link

<< Home