Lookup warnings

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
snt_ds
Premium Member
Premium Member
Posts: 280
Joined: Wed Oct 18, 2006 11:53 am
Location: Pune, India

Lookup warnings

Post by snt_ds »

Hi All,

I'm getting the below warning while I'm doing the lookup.

please let me know how to handle this.

Lookup_115: When checking operator: Operator of type "APT_OraLookupOperator": will partition despite the
preserve-partitioning flag on the data set on input port 0.

Thanks
Suresh
bcarlson
Premium Member
Premium Member
Posts: 772
Joined: Fri Oct 01, 2004 3:06 pm
Location: Minnesota

Post by bcarlson »

For a more complete explanation, I would suggest searching to forum on "will partition despite the preserve-partitioning flag".

Nutshell description - partitioning is set and passed on to downstream stages. A stage can choose to adopt the partitioning of the prior stage or change it. You can set a flag to preserve partitioning downstream. This warning basically says that it is overriding the option.

Again, for more information I highly recommend a search. There is a ton of information out there in this forum and, no doubt, plenty on your warning - and maybe more accurate :wink:

Brad.
kool78
Participant
Posts: 104
Joined: Sat Aug 20, 2005 2:02 pm

Post by kool78 »

Hi,

from the warning message it looks like you are repartitioning the data and not clearing the previous partition( from the previous stage).

Make sure you clear the previous parititong before repartitiong the data.
"Attitude always and almost determines the altitude of your Life"
Post Reply