Partitioning and Collecting Data - Related Stage Properties

1.   Preserve Partitioning Flag

This flag is present in the stage properties:

Stage Properties window -> Stage Page -> Advanced tab

Values it can take:

a.     Set:

Setting this flag requests the next stage in the job to preserve whatever partitioning the current stage has implemented. Note, however, that the next stage might ignore this request.

b.    Clear: The next stage is free to partition the data.

c.     in the job has set. If the stage has multiple inputs and has a flag set to Propagate, its Preserve Partitioning flag is set if it is set on any of the inputs, or cleared if all the inputs are clear.

2.   Partition Type (where do we specify)

This flag is present at in the stage properties:

Stage Properties window -> Inputs Page -> Partitioning tab