Difference between Set and Propagate Partitioning?

SettValleyConsulting · Thu Mar 20, 2008 10:13 am

What is the difference between 'Set' and 'Propagate' in the 'Preserve Partitioning' Drop-Down box (usually on the Advanced Tab)?

A colleague encountered the 'Partitioning despite the Preserve Paritioning Flag' warning. I advised to change the Propagate option to 'Clear', he pointed out that he wanted to preserve the partitioning.

Changing the Preserve option to 'Set' removed the warning, and retained the functionality of the job.

The Developers guide just has : This is Propagate by default. It adopts the setting of the previous stage.You can explicitly select Set or Clear. Select Set to request the stage should attempt to maintain the partitioning which is less than crystal.

rgds

Phil Clarke.

DSguru2B · Post by **DSguru2B** » Thu Mar 20, 2008 10:16 am

Propogate partitioning will preserve the partitioning the data went through in the previous stage, where as clear will clear it and repartition to whatever partitioning is specified in the current stage. Please Search on the warning message. This has been discussed before.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 20, 2008 5:06 pm

"Set" is mandatory. "Propagate" is advisory.

SettValleyConsulting · Tue Apr 08, 2008 9:45 am

Thanks Ray. That simple, huh? Is this documented anywhere?

DSGuru - the question you answered was not the question I asked.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 08, 2008 3:08 pm

Not in so few words. You have to struggle through the verbiage, but it's there.