Archives of the TeradataForum

Message Posted: Mon, 12 Sep 2005 @ 13:36:16 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Interesting you should ask, yes, actually, the IN parameter for the SP is VARCHAR(100) and the OUT parameter is VARBYTE(100). Informatica uses the data type of BINARY (size 100). The transformation that calls the SP is suppose to pass the OUT parm to the TARGET which is Teradata table whose column is defined as VARBYTE(100). The "binary" out port is mapped to the VARBYTE in port of the Target. I find no other way to do this...in any case, in following the ODBC trace, I know the correct binary data is coming back from Teradata, it is just not being bound to the Out port in the transformation.

Michael E. McBride, MSCIS

	<Prev	Next>		<<First	<Prev	Next>	Last>>