...
- The 'INF Windows Systems' department (Infrastructure group) is responsible for the source data source; the technical POC is Julio Valdes.
- data will be loaded daily at midnight
Transformation Logic
- serial number, os version, and name are directly mapped.
- coalesce on serial number (target table enforces uniqueness).
- name, per the query, is the host + first FQDN suffix of the machine.
- os family is always 'Windows'
- group is always 'INF Windows Systems'
- ci owner is always manager of 'INF Windows Systems'