Page 1 of 1

metadata mismatch

Posted: Fri Nov 07, 2008 12:14 pm
by radarada
The source metadata was imported through the orchestrate schema. The field in the table is defined as a CHAR(1) however when the job runs the Oracle stage throws out the below error.

Implicit conversion from source type "string[max=32]" to result type "string[1]"

This field does not exists as anything but CHAR in the environment we are pulling from. Where does DS get this info as several other fields also had the same issue in that the string was higher in DS then on the database.

Posted: Fri Nov 07, 2008 12:37 pm
by ray.wurlod
CHAR is the same as Char(1) is the same as string[1]

Posted: Fri Nov 07, 2008 12:42 pm
by radarada
right but the error is telling me that DS is reading that the source has a string 32 and i am trying to put it into a string 1. The source has a char(1) and my job has a char(1). Where is it getting the string 32?