SCD: the blank purpose code

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

SCD: the blank purpose code

Post by fmou »

"The SCD stage provides nine purpose codes to support dimension
processing. The (blank) means that the column has no SCD purpose. This purpose code is the default."
I'm wondering what the blank purpose code actually means. If my scd dimension has a field which purpose code is blank, will that field never get updated?

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

Post by ray.wurlod »

That is correct.

It is useful for fields that don't have any meaning at all in the history, for example fields like COMMENTS.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”