Sha256: 04e4455042f6c93fef86d319124156007675937909850c405a0f5b927d9b2c17
Contents?: true
Size: 663 Bytes
Versions: 4
Compression:
Stored size: 663 Bytes
Contents
source :in, {
:file => 'data/delimited.txt',
:parser => {
:name => :csv
}
},
[
:first_name,
:last_name,
:ssn,
:age,
:sex
]
#transform :age, :type, :type => :number
transform :ssn, :sha1
transform(:ssn){ |n, v, row| v[0,24] }
transform :sex, :decode, {:decode_table_path => 'data/decode.txt'}
destination :out, {
:type => :insert_update_database,
:target => :data_warehouse,
:database => 'etl_unittest',
:table => 'people'
},
{
:primarykey => [:id],
:order => [:id, :first_name, :last_name, :ssn, :age, :sex, :test, :calc_test],
:virtual => {
:id => :surrogate_key,
:test => "test!",
:calc_test => Time.now
},
}
Version data entries
4 entries across 4 versions & 3 rubygems