Project

General

Profile

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