[Lilug] Poor mans ETL processing

Peter Capazzi Peter.Capazzi at TranzactIS.Com
Tue Feb 24 12:21:08 PST 2009


At our work place we use a software that has a pretty heavy price tag.
I'm actually not supposed to mention it by name. Anyway, the more I work
with and the more I learn about linux I see some similarities between
commands in linux and the functions in this application. 
 
I was wondering if there was a "poor man"s ETL engine that is simply a
front end to commands like these:
sort - sorting datasets on a field
join - merging data sets
cut - field selections/exclusions
cat - for input files
sed - To modify fields
grep - To filter
awk - To modify fields and partition datasets. 
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lilug.org/pipermail/lilug-lilug.org/attachments/20090224/2d8ac29f/attachment.htm>


More information about the Lilug mailing list