Pages

Sunday, 22 September 2013

Partitioning and Collecting Icons

These icons keep appearing in the jobs. Here, is a description what each of these actually mean:

1.AutoPartitioning: 

2.Repartitioning: 

3.Partitioning: 

4.SamePartitioning: 

5.Collector: 

Note : Though matter related to different datastage concepts are prevalent on the net and can be gathered from various sources, mine is an attempt to present the matter in an easy to understand manner.  

Monday, 19 August 2013

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