warning in lookup

ketanshah123 · Post by **ketanshah123** » Sun Jun 22, 2008 11:50 pm

Hi
While doing lookup between db2 database and dataset as ref. getting 2 warning messages
1) Lookup_CNUM: When checking operator: Operator of type "APT_LUTCreateOp": will partition despite the
preserve-partitioning flag on the data set on input port 0.

2)Lookup_CNUM,0: When binding input interface field "CNTRCTR_CNUM" to field "CNTRCTR_CNUM": Implicit conversion from source type "string[10]" to result type "string[9]": Source string will be truncated.

In the 2nd warning mesage just changing length of field will do ?

How to resolve these warning messages ?

Thnax in advance

keshav0307 · Post by **keshav0307** » Sun Jun 22, 2008 11:59 pm

1. in the previous stage you have choosen to preserve the partition, if you are explicitly re partitioning then in the previous stage to this, choose clear partition.

2. use modify stage to changing length or datatype

AKUMAR21 · Post by **AKUMAR21** » Mon Jun 23, 2008 1:20 pm

Why to use a modify stage, Keshav? We can directly change it in the input/output metadata of the lookup stage.