Contents

# puts "executing delimited.ctl"

source :in, {
  :file => 'data/delimited.txt',
  :parser => :delimited
}, 
[ 
  :id,
  :first_name,
  :last_name,
  :ssn
]

transform :ssn, :sha1
transform(:ssn){ |v| v[0,24] }

destination :out, {
  :type => :database,
  :target => :data_warehouse,
  :database => 'etl_unittest',
  :table => 'people',
},
{
  :order => [:id, :first_name, :last_name, :ssn]
}

Version data entries

2 entries across 2 versions & 2 rubygems

Version	Path
activewarehouse-etl-0.9.5.rc1	test/delimited_destination_db.ctl
balinterdi-activewarehouse-etl-0.9.2	test/delimited_destination_db.ctl