Re: Help on ETL
- From: "Peter Nolan" <peter@xxxxxxxxxxxxxx>
- Date: 20 Jul 2005 14:05:58 -0700
Hi JT,
That's the 'free' stuff that includes many of the features needed to
build a DW....we used it in many clients in the 90s......(I've been
doing DWs since 1991 when C++ was a novelty and Java was a long time
from being invented....and cobol was still lingua franka of all
computing.....) I published it because I am often asked how to build
the ETL code to load type1/2 dimensions, facts, summaries etc.....my
answer was..."here is the code you need to replicate the functionality
of for free." I can't do much more than that for
free....(LOL).....also, because there are so many ETL tools, and they
have collapsed their processing and data structures, it's almost
pointless to publish code that loads DWs in any particular tool. I
released templates for loading Sybase IWS in DataStage and Informatica
and got absolutely no interest in them at all...which surprised me.....
The advanced C++/ODBC current version of our software that runs across
a variety of platforms, is not free so it's not published...;-) Though
I have published a lot of the source code for the free utilities my
company has released......email me if you want the address of our
company. my personal email is peter@xxxxxxxxxxxxxxx I don't want to be
putting my company address here...to much like advertising and I don't
want to do that here...
You might not believe this, but I believe there is still more cobol
code out there than C++/Java/VB etc put together......all speaking King
James english... (LOL)!!!
Peter
.
- References:
- Re: Help on ETL
- From: JT
- Re: Help on ETL
- Prev by Date: Re: DW with WInXP
- Next by Date: Re: Migrating Analysis Services Roles
- Previous by thread: Re: Help on ETL
- Next by thread: Re: msmdsrv.exe takes more than 95% cpu
- Index(es):
Loading