Skip to content
This repository has been archived by the owner on May 21, 2024. It is now read-only.

A few useful things for ActiveWarehouse-ETL and the likes

License

Notifications You must be signed in to change notification settings

activewarehouse/etl-goodies

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

=> [email protected]

About

A few useful things for ActiveWarehouse-ETL and the likes

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published