DSXchange

Hi All,

I have been using Lookup stage with both links partitioned as "Auto" for all the jobs developed so far.

I have the understanding that internally lookup stage uses "entire" partitioning on the reference link if we choose "Auto".

Is there a possibility of above not being true ? (Considering everything is normal and no env variables set etc.)

Now I know a person (happens to be my job reviewer) who thinks Entire is not default partitioning method for reference link and we have to explicitly specify (Entire) on the reference link.

Also is it true that a stages default partition method (one chosen by Datastage when Auto is selected) can differ with versions/releases of Datastage?

Appreciate your help..
Thanks

ravindras83 wrote:I have the understanding that internally lookup stage uses "entire" partitioning on the reference link if we choose "Auto".

Is there a possibility of above not being true ? (Considering everything is normal and no env variables set etc.)

No. You can prove this by inspecting the score.

ravindras83 wrote:Now I know a person (happens to be my job reviewer) who thinks Entire is not default partitioning method for reference link and we have to explicitly specify (Entire) on the reference link.

This person is wrong.

ravindras83 wrote:Also is it true that a stages default partition method (one chosen by Datastage when Auto is selected) can differ with versions/releases of Datastage?

No. At least not so far (version 9.1.2).