Preserver Partion - Clear + Same partition

dsdoubt · Post by **dsdoubt** » Thu Apr 02, 2015 12:37 pm

I have the Looup stage with Reject to a Sequential file stage.

I get the follwing warning.

A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.

I can 'Clear' the Preserver Partition of the Lookup.

But other stages that are connected to Lookup, would need the 'Same' partition as the lookup.
Will the other stage be affected based on the Preserver partition change?

SwathiCh · Post by **SwathiCh** » Thu Apr 02, 2015 5:40 pm

If you clear the partition then Datastage tries to repartition the data on link before next stage but as you are having "SAME" partition on that link, datastage should through the warning.

By the way, why can't you have a copy stage on reject link before sequential file and clear the partition on copy?

dsdoubt · Post by **dsdoubt** » Mon Jun 08, 2015 11:51 pm

Adding copy stage is always an option. But I was actually of 'Clear' the Preserver Partition option, if that would work to avoid an extra stage.