Warning while loading the Look up file set

phanee_k · Post by **phanee_k** » Wed Mar 30, 2005 6:55 am

Hi ,
When I am loading the Look up file set, the below warning is appearing constantly.

Operator of type "APT_LUTCreateOp": Will partition despite preserve-partitioning flag on dataset on input port 0

The partition type used is "Entire".

What could be the reason and how to resolve it.

thanks,
Phani

roy · Post by **roy** » Wed Mar 30, 2005 7:22 am

Hi,
It seems the engine decided that it must repartition to get the job done for some reason.
In order to give a reason we'll need more info regarding the job design.

phanee_k · Post by **phanee_k** » Wed Mar 30, 2005 7:29 am

In this job,
I am extracting data from the oracle table, doing lookup against some tables doing some aggregations and loading to the final output to the target table and as well to the Lookup file set.

Everything is going on smoothly.But at the time of loading the data I am getting this error.

--Phani

T42 · Post by **T42** » Wed Mar 30, 2005 10:56 pm

That warning message is typical for EE. In order to fix this, you need to go to the previous stage, click on its properties, select the "Advanced" tab, set "Preserve Partitioning" to "Clear".

This is caused by the default behavior of DataStage which is to preserve partitioning. This is a very harmless warning message, used to say, "Hey, you're changing something here, are you sure this is the correct behavior you've chosen?"

phanee_k · Post by **phanee_k** » Thu Mar 31, 2005 4:40 am

Thanks for the info.
It worked fine.

Thanks,
Phani