Entire Partitioning on lookup reference link

[ravindras83]

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

[ray.wurlod]

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.

[ray.wurlod]

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.

[ray.wurlod]

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).