New release of OneClickETL script available for download - OneClickETL-0.1.1.tcl.
Now it allows generate mappings with SCD Type 1 loading type.
Updated Excel file OneClickETL_OE2SH.xls contains additional sheet for SCD1 mapping.
Example of specification for SCD1 mapping
To generate SCD1 mapping specify in C1 cell "SCD1" value. In D column you need to specify role for target columns:
- PRIMARYKEY - this column will be used for matching condition
- TRIGGEREDATTRIBUTE - this column willbe inserted and updated
- empty cell - this column will be only inserted
Now it allows generate mappings with SCD Type 1 loading type.
Updated Excel file OneClickETL_OE2SH.xls contains additional sheet for SCD1 mapping.
Example of specification for SCD1 mapping
To generate SCD1 mapping specify in C1 cell "SCD1" value. In D column you need to specify role for target columns:
- PRIMARYKEY - this column will be used for matching condition
- TRIGGEREDATTRIBUTE - this column willbe inserted and updated
- empty cell - this column will be only inserted
No comments:
Post a Comment