Page 1 of 1

warning in lookup

Posted: Sun Jun 22, 2008 11:50 pm
by ketanshah123
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

Posted: Sun Jun 22, 2008 11:59 pm
by keshav0307
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

Posted: Mon Jun 23, 2008 1:20 pm
by AKUMAR21
Why to use a modify stage, Keshav? We can directly change it in the input/output metadata of the lookup stage.