Importing to a denormalized VegCore schema¶
time estimate¶
total: 1-2 weeks [6-9 days]
task | time |
create denormalized VegCore schema | 1-2 days |
denormalize the remaining normalized datasources: TEAM, Madidi | 2 days |
for each datasource, create a materialized view generated by inserting the denormalized view or staging table into the denormalized VegCore schema | 2-4 days |
set each datasource to use the VegCore materialized view in the normalization process | 1 day |