'SCD2 on nested table in GCP big query
I am new to gcp big query. I am trying to model scd2 implementation on both outer and nested table on GCP big query. I would like to know your suggestions wether scd2 implementation on nested table is possible? if so I would highly appreciate a pseudo code and pointers
eg. Employee is the Dimension with SCD2 on many attributes. Also Skills is nested table in employee with its own attributes and SCD2 logic.
Note : Assume every employee have lot of skills and they keep changing very frequently, so it doesn't make sense to have them tracked as part of outer table.
- EmpID
- EmpName
- EmpAddress
- EmpAttributexyz
- EmpSkill( nested table) - columns.
1. Skilid 2. SkillName 3. ValidFrom 4. Valid To - EmpValidFrom
- EmpValidTo
Regards, Suman
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|