Type 1 and Type 2 co-exist in SCD

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
fmou
Participant
Posts: 124
Joined: Sat May 28, 2011 9:48 pm

Type 1 and Type 2 co-exist in SCD

Post by fmou »

Hi,

I know that,
"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)."
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?

thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

No, because there is no Type2 change to warrant creating a new record.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply