DSXchange

check the length of that column in the modify stage output link.

After changing the source and reference link key to varchar(1) datatype, earlier it was varchar(1) and varchar(30) in the source and reference link, the job is running successfully without any issues.

Thank You for all your help.

Before the lookup, I did all the necessary transformation, I had earlier sent you the table column definition (DDL)

the source link key is columnA char(1) nullable = Yes and the reference link key is column A varchar(30) nullable = No

I run the job by increasing the length to varchar(10), but again I am getting the same error.

Lookup is having a single reference link and I tried running the job with 10 records only and Key column is of Varchar (1) datatype.

Lookup is having a single reference link and I tried running the job with 10 records only and Key column is of Varchar (1) datatype.

Lookup stage and Lookup key column is throwing this error.

While running a job, I am getting the following error.
Field "column name" has keyprep export buffer overrun error. Has anyone come across this error before? I searched in the forum but couldnt find any solution.

I am having a look up stage with 3 reference link.The reference link source is DB2 Connector Stage. After DB2 Connector Stage I am having a copy stage. The output of copy stage is having 3 reference link. Can you suggest which of the following partition is the best and why? Or is there any other par...