in reply to Perl to generate code in other languages
My current job is lead ETL development on a multi-district "Public Education" (K-12)data warehouse. I'm using Perl to extract, generate DDL transformations, Oracle load processes and generate Cognos objects.
Perl is my life-preserver. Some of my sources have, literally, 9-20k tables. I've abstracted, aggregated, profiled, translated, filtered, verified, converted, surrogated and documented, all with Perl code.ETL is more about operations than is is development. If the code still works, why bother refactoring it? Answer: You have a novice around! See: Principle of Lease Qualified Implementer.
To those truly wanting to follow The Path, allow me to provide another forks in the road. K. Czarnecki, s. Helsen; Feature-based survey of model transformation approaches IBM Systems Jounal Vol 45 No 3, 2006. My mind exploded with ideas from this one!
Code generation and patterns provide something useful and interesting to do at the office. I helps me to keep my "Beginner's Mind"
I've recently signed up for PAUSE so that I can contribute some module code -- probably to SQL::Translater -- specifically for Oracle 9+. Its amazing how dated most Oracle support is within CPAN (Metadata API has been around for years...)
Anyone else out there notice a similarity between Perl Monks and Scientology? Who's hiding all the secrets to make ETL easy? It this job security or religion?
So, while I have not provided any concrete examples that I've grown, hopefully I can help "make the soil richer." Nice post -- looking forward to see what this captures.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: Perl to generate code in other languages
by planetscape (Chancellor) on Dec 07, 2007 at 04:29 UTC |