I know that,
What I want to confirm is that, if in a SCD stage, both Type 1 and Type 2 type of columns exist, but the changed columns only limit to those of Type 1, will a new dimension record still be created first?"If both Type 1 and Type 2 changes exist for the same record, the
Type 2 change takes precedence over the Type 1 change. This means that a
new dimension record is first created, and then the Type 1 changes are
applied to the newly created record only. The Type 1 changes in this case are
not reflected in the earlier row(s)."
thanks