RE: Of ELT, and yes, Horton gives a hoot

edge_dave — Thu, 05 Feb 2009 17:49:07 GMT

Great post, David - just thought I'd throw in a couple of comments re 3rd party 'ELT' style products..

Before it got bought by Oracle, Sunopsis enabled some of what you describe, and I see from a recent blog posting that Informatica's PushDown Option (PDO) now includes Netezza support. I've done some experimentation with earlier Informatica PDO versions on Netezza, and they're certainly going in the right direction. Many (though not all) transformations (e.g. aggregations, look-ups, some expressions, sorts, joins, unions..) can be pushed down to the Netezza system if the source and target are on the same connection. So the system is capable of generating INSERT.... SELECT.. type code from a mapping described in the normal developer GUI, while retaining the appropriate metadata in the Informatica repository.

This doesn't however mean that an existing 'Oracle style' mapping will generate pushed down code if the source and target are migrated to Netezza... to get the best out of this functionality will generally require a rethink in approach, just the same as when 'hand coding' the ELT operations.

I'll hopefully be doing some work with the latest Informatica version very soon - I'll report back on what I find out.

Principal Consultant

Edge Assoicates

Gather 'round the Grill

RE: Of ELT, and yes, Horton gives a hoot