kirangvr

 Profile Answers by kirangvr Questions by kirangvr

• Jan 23rd, 2007

 

o Round-Robin: PC server distributes rows of data evenly to all partitions. @filtero Hash keys: distribute rows to the partitions by group. @rank, sorter, joiner and unsorted aggregator.o Key range: distributes rows based on a port or set of ports that you specify as the partition key. @source and targeto Pass-through: processes data without redistributing rows among partitions. @any valid partition point.Hope ot helps you.

sreedhark26

 Profile Answers by sreedhark26 

• Mar 12th, 2007

 

When you create or edit a session, you can change the partitioning information for each pipeline in a mapping. If the mapping contains multiple pipelines, you can specify multiple partitions in some pipelines and single partitions in others. You update partitioning information using the Partitions view on the Mapping tab in the session properties.

You can configure the following information in the Partitions view on the Mapping tab:

• Add and delete partition points.
• Enter a description for each partition.
• Specify the partition type at each partition point.
• Add a partition key and key ranges for certain partition types.

dl_mstr

 Profile Answers by dl_mstr 

• Feb 10th, 2008

 

By default when we create the session, workflow creates pass-through partition points at Source Qualifier transformations and target instances.

 Partition points mark the thread boundaries in a source pipeline and divide the pipeline into stages. A stage is the section of a pipeline executed between any two partition points. When you set a partition point at a transformation, the new pipeline stage includes that transformation.