Hi,
I've just started working with activewarehouse-etl to do some etl
operations between an existing legacy db and a new rails app.
I'm trying to use Type 1 SCD to make changes to existing rows in the db
rather than writing a new record every time there is a change. At the
moment, I'm just trying to prove the concept with a simple example which
moves data between two dbs with no changes.
The .ctl file I've created is below. I'm having trouble seeing how I can
tell it that record x should map to record x' in the destination
database. I'm sure I'm missing something obvious, Please help!
Also, I'm willing to update the documentation around SCD's with whatever
I learn here - how do I go about it?
Many thanks,
Toby.
----------------- groups.ctl -----------------------
source :in,
{:type => :database,
:target => :legacy,
:table => 'groups'},
[:group_code, :name, :email]
destination :out, {
:scd => {:type => 1 },
:scd_fields => [:email],
:type => :database,
:target => :development,
:table => 'groups'
},
{
:order => [:group_code, :name, :email]
}
_______________________________________________
Activewarehouse-discuss mailing list
Activewarehouse-discuss@rubyforge.org
http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
