Page 1 of 1

keyChange Column type conversion

Posted: Tue Apr 26, 2005 7:32 am
by ds_is_fun
Im sorting data using Sort Stage. In the Sort stage Im using Create Key Change Column option. The keyChange datatype by default is TinyInt.
I need to use it as a calculation for a Integer and Decimal(9,2) type datatype target columns.
How do I go about the type conversion?

Posted: Tue Apr 26, 2005 8:14 am
by ArndW
I would expect the tinyInt to be useable in a transform computation - but if not then you would have to do a cast either in the transform itself or resort to the use of a MODIFY stage to change the datatype explicitly.