A few useful things for ActiveWarehouse-ETL and the likes
Switch branches/tags
Nothing to show
Pull request Compare This branch is even with activewarehouse:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
lib
spec
LICENSE
README.textile
Rakefile

README.textile

WHAT’S HERE ?

I’m sharing tools I’m using when I build Datawarehouses using ActiveWarehouse-ETL.

QUICK DESCRIPTION

  • CsvHelper – allows to:
    • extract csv columns names in a stable fashion
    • returns all the values of a specific column
  • FixedWidthFileDestination : if you’re outputting stuff to COBOL machines
  • DimensionMigrationHelper : useful for ActiveRecord migrations
  • French(Date/Time)DimensionBuilder : fine-grained date/time dimensions in french
  • EnsureFieldsPresenceProcessor : raises error as soon as one field is missing from a row
  • EscapeCSVProcessor : replaces \" by "" in hope FasterCSV will be able to munge your CSV afterwards
  • CleanUpTransform : like AW-ETL DecodeTransform, but leave the original value if no match is found

RUNNING SPECS

rake spec

Note: you’ll need to gem install activewarehouse-etl and fastercsv

TO BE ADDED

  • chunk-splitters bulk load processor to cope with mysql timeouts on Windows

=> thibaut.barrere@gmail.com