Source-to-target Mapping Template

Source-to-target Mapping Template

The purpose of source-to-target mapping is to provide detail explanation of what happens to the data from the moment it is extracted from the source to when it is loaded into the target data warehouse table. It defines both schema of target table and all required transformation rules, insert/update/delete logic, history tracking rules, LAD mechanisms description. STTs are used as a primary document for development and testing activities. Full set of STTs provides comprehensive vision of DW/ETL system.