lookup warning

prams · Post by **prams** » Wed Apr 29, 2009 1:09 am

Hi All,
In one of my job i have used lookup stage to do lookup with oracle database stage and then i am filtering by using filter stage after that in lookup i am partioning(hash) based on lookup key.
but it is giving the folowing warning like "When checking operator: Operator of type "APT_LUTCreateOp": will partition despite the
preserve-partitioning flag on the data set on input port 1."

Please any one help me

Thanks in Advance
Prams

ray.wurlod · Post by **ray.wurlod** » Wed Apr 29, 2009 1:10 am

Search - this exact question has been answered a bazillion times.

prams · Post by **prams** » Wed Apr 29, 2009 1:34 am

Hi Ray,

i have set preserve partion as clear in the lookup stage.

even though i am getting the same waring.

Please help me in this.

Thanks in Advance

ray.wurlod · Post by **ray.wurlod** » Wed Apr 29, 2009 2:03 am

Input port 1 is the (first) reference input to the Lookup stage. Go to the properties of the stage at the other end of that link, and set preserve partitioning to Clear there.

nirdesh2 · Post by **nirdesh2** » Wed Apr 29, 2009 3:19 am

Clear the partitioning on the links that are coming to Lookup stage.

prams · Post by **prams** » Wed Apr 29, 2009 4:27 am

ray.wurlod wrote:Input port 1 is the (first) reference input to the Lookup stage. Go to the properties of the stage at the other end of that link, and set preserve partitioning to Clear there. ...

Hi Ray

Thanks for the replay, and i have done the same thing as you mentioned.
But still the warning is coming.

after that i have set preserve partitoning flag for all the stages in job, even though i am getting the same warning.

Thanks & Regards
Prams

prams · Post by **prams** » Wed Apr 29, 2009 4:31 am

nirdesh2 wrote:Clear the partitioning on the links that are coming to Lookup stage.

Hi

If i clear all the partitions to lookup stage then i am getting like this warning.
" Ignoring duplicate entry at table record 15270; no further warnings will be issued for this table"
any how i need to eliminate duplicates thas why i am doing hash partioning based on lookup key.

if have any idea to sove this problem, please help me

Thanks
Prams

throbinson · Post by **throbinson** » Wed Apr 29, 2009 5:46 am

It seems to me you need to take a step back and think about doing a little research/learning on the tool. This specific problem has been answered in this forum, if not a bazillion then certainly a gazillion times. Do a search man! It is your friend. In the time it takes to ask, you'd have been answered with a search.

any how i need to eliminate duplicates thas why i am doing hash partioning based on lookup key.

Oh mama!