Data Elements that are Sequence Numbers

In "parent table" "child table" situations, where there can be more than one child row for a given parent row, the key for the child is usually a composite key consisting of the parent key plus at least one other element. A sequence number element may be generated in the CIW transformation process if no combination of the other elements in the child table can combine with the parent key elements to make a satisfactory child key. The name of such an element should end with "_SEQUENCE_NUM" or "_SEQ".