Home

Welcome to the TEAM wiki!

The TEAM / metadata model is available here: https://app.quickdatabasediagrams.com/#/schema/nGUNeb2jEki0XoJ3iemkMQ

Contents / functionality of the tool:

• Connectivity settings and configuration including opening and saving to file.
• Metadata management (grid, mapping Source-to-Target Mapping - STM)
• Activation and validation of metadata (checking and pushing into target DV generation data model)
• Repository creation
• Physical model versioning and reverse-engineering, to enable virtualisation
• Test data generator (also to support RI check, but that's in the virtualisation)
• Source system register (NOT DEVELOPED YET)

---

Changes in MD model (Metadata Model / TEAM):

---

2018-01-03

• Summary: major update to MD model to incorporate various generation changes to fully separate DIRECT and TEAM)
• Intent: making sure all generation metadata is made available in MD / TEAM and all process control and execution metadata is captured in DIRECT. Everything now in sync across the board.
• Changes:
  • Renamed MD_SOURCE_CDC_TYPE_XREF to MD_STG_CDC_TYPE_XREF
  • Added GENERATE_INDICATOR to MD_STG_CDC_TYPE_XREF. This is to be used to exclude certain ETLs from being generated.
  • Added CHANGE_DATETIME_DEFINITION to MD_STG_CDC_TYPE_XREF. This is to pre-calculate business effective dates, if required.
  • Updated INTERFACE_VIEW
  • Added MD_SOURCE_SYSTEM
  • Added MD_SOURCE_DATASET
  • Updated MD_SOURCE_STG_XREF to have a FK to SOURCE_DATASET_ID
  • Added GENERATE_INDICATOR TO MD_TABLE_MAPPING. This is to exclude certain ETLs from being generated.