One of my clients deals with educational institutions and student
test evaluations for the purposes of improving teaching methods for instructors.
The challenge is that when students respond to teacher evaluation questionnaires, the questions can be customized by the teachers. The concept of Project (
HUB)
designates a particular semester and is a centralized
HUB. The concept of Response (
HUB) is a challenge, since it is dynamically generated by the client
ERP/
ETL tool. For example, when a response is generated by a student responding to a questionnaire, a dynamic Project ID (PID Key) is created for the particular dynamic response table. For example, PID+Response would be a dynamically generated table. It has other tables that give it context and that store history which can be considered as the
SATELLITES.
Sorry for the long winded explanation, by I had to give the back story prior asking my question. So, my questions are:
- How do I model for these dynamically created tables which create these Project autokeys all over the place whenever students respond to questionnaires?
- They can have about 100 of these dynamically generated tables based on the customized questions as defined by the instructors. Would this be modeled as multiple
HUBs in the
Data Vault?
- If so, doesn't this increase the complexity of the DV model by having these dynamically created
HUBs in the model?
Any guidance would be very appreciated.
Thanks kindly in advance,
Shawn